home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC-SIG: Essential Home & Business
/
PC-SIG - Essential Home and Business Collection.iso
/
24
/
1
/
4
/
DISK2414.ZIP
/
SYSTEM.DOC
< prev
next >
Wrap
Text File
|
1991-06-19
|
193KB
|
3,509 lines
██████████████████████████████████████████████████████████████████████████████
█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█
█░ ░█
█░ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ░█
█░ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ░█
█░ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ░█
█░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ░█
█░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ░█
█░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ░█
█░ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ░█
█░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ░█
█░ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ░█
█░ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ░█
█░ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ░█
█░ ░█
█░ ▄█████▄ █░ █░ ▄████▄ ███████░ █████░ █░ █░ ░█
█░ █░ █▄ ▄█░ █░ █░ █░ ██░ ██░ ░█
█░ █░ █▄ ▄█░ █░ █░ █░ ███░███░ ░█
█░ ▀█████▄ █▄█░ ▀████▄ █░ ███░ █░███░█░ ░█
█░ █░ █░ █░ █░ █░ █░ █░ █░ ░█
█░ █░ █░ █░ █░ █░ █░ █░ ░█
█░ ▀█████▀ █░ ▀████▀ █░ █████░ █░ █░ ░█
█░ ░█
█░ █░ █░ █░ █░ █░ █░ ▄████▄ █████░ █▄███▄ ░█
█░ ██░ ██░ █▀█░ ██░ █░ █▀█░ █░ █░ █░ █░ ░█
█░ ███░███░ █░█░ ███░ █░ █░█░ █░ █░ █░ █░ ░█
█░ █░███░█░ █▀ ▀█░ █░██░█░ █▀ ▀█░ █░ ███░ █▄▄▄▄█░ ░█
█░ █░ █░ █░ ▄█▄▄▄█▄ █░ ███░ ▄█▄▄▄█▄ █░ ▀█░ █░ █░▀█░ ░█
█░ █░ ▀ █░ █░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ ▀█░ ░█
█░ █░ █░ █░ █░ █░ █░ █░ █░ ▀████▀ █████░ █░ ▀█░ ░█
█░ ░█
█░Copyright (c) 1990-91, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366░█
█░ ░█
█░ DAYO BUSINESS APPLICATIONS ░█
█░ Version 2.0 ░█
█░ ░█
█░ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ░█
█░ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ░█
█░ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ░█
█░ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ░█
█░ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ░█
█░ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ░█
█░ ▀▓▓▓▀ & LAN █████■████▌ O A ░█
█░ Applications ▐███████████ N R ░█
█░ ┌─┐ ┌─┐ ███████████▌ S E ░█
█░ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ░█
█░ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L &░█
█░ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ░█
█░ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ░█
█░ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ░█
█░ █ G ░█
█░ ▄▄▄▄▀ ░█
█░ ░█
█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█
██████████████████████████████████████████████████████████████████████████████
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-1991, TJS LAB
Table of Contents
Page Subject
──── ───────────────────────────────────────
1 ............... INTRODUCTION
3 ............... REQUIREMENTS
3 ............... COPYRIGHT/LICENSE
3 ............... DISCLAIMER
4 ............... SETUP & OPERATION
5 ............... HOME DIRECTORIES FOR THE DATABASES
8 ............... DAYO APPLICATIONS
8 ............... INVENTORY
8 ............... POS
8 ............... PRICE BOOK
9 ............... QUOTES
9 ............... INDEX
9 ............... PASSWORDS
9 ............... DAYO BACK ORDERS
9 ............... AR (ACCOUNTS RECEIVABLE)
9 ............... AP (ACCOUNTS PAYABLE)
10 ............... GL (GENERAL LEDGER)
10 ............... LOOK UP
10 ............... DAYO EOP
10 ............... DAYO SMART REPORTS
10 ............... MENU
10 ............... CLOCK
11 ............... UPDATE
11 ............... MRP (MATERIALS REQUIREMENT PLANNING)
11 ............... PAYROLL
11 ............... TIME & BILLING
12 ............... DAYO BAR CODE 3 of 9
12 ............... DAYO MEMBERSHIP
12 ............... DAYO ORDER ENTRY
12 ............... DAYO SHIPPING LOG
12.1............... DAYO RENTAL POS
12.1............... UPDATE & CONVERSION
12.2............... DAYO PRICE LIST
13 ............... DATABASE STRUCTURES
13 ............... DATABASE: ACCOUNTS.DBF
13 ............... DATABASE: ALLOCATE.DBF
14 ............... DATABASE: APD.DBF
15 ............... DATABASE: APH.DBF
15 ............... DATABASE: APPLIED.DBF
15 ............... DATABASE: ARJ.DBF
16 ............... DATABASE: ARH.DBF
17 ............... DATABASE: ARD.DBF
17 ............... DATABASE: BO.DBF
18 ............... DATABASE: BOM.DBF
18.1............... DATABASE: CFORMAT.DBF
19 ............... DATABASE: CHECKS.DBF
20 ............... DATABASE: CUSTOMER.DBF
21 ............... DATABASE: CUSTMEMO.DBF
21 ............... DATABASE: DAYOHELP.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-1991, TJS LAB
Table of Contents Continued...
Page Subject
──── ───────────────────────────────────────
21 ............... DATABASE: DAYOMENU.DBF
21 ............... DATABASE: DAYOX.DBF
22 ............... DATABASE: DEPOSITS.DBF
22 ............... DATABASE: DETAIL.DBF
23 ............... DATABASE: ENDITEMS.DBF
23 ............... DATABASE: EXPENSES.DBF
24 ............... DATABASE: GL.DBF
25 ............... DATABASE: GLCLASS.DBF
25 ............... DATABASE: GLDEPT.DBF
25 ............... DATABASE: GLHIST.DBF
26 ............... DATABASE: GLPERIOD.DBF
26 ............... DATABASE: GLTABLED.DBF
26 ............... DATABASE: GLTABLEH.DBF
26 ............... DATABASE: GLTRANS.DBF
27 ............... DATABASE: INV.DBF
28 ............... DATABASE: INVADJ.DBF
29 ............... DATABASE: INVOICE.DBF
29 ............... DATABASE: LOOKUP.DBF
30 ............... DATABASE: PAY.DBF
34 ............... DATABASE: PAYHIST.DBF
34 ............... DATABASE: PAYNOTES.DBF
35 ............... DATABASE: PAYROLL.DBF
36 ............... DATABASE: PAY_SUM.DBF
36 ............... DATABASE: PB.DBF
37 ............... DATABASE: PDRIVER.DBF
37 ............... DATABASE: PHYINV.DBF
38 ............... DATABASE: POD.DBF
38 ............... DATABASE: POH.DBF
39 ............... DATABASE: PROJECTS.DBF
40 ............... DATABASE: QTR_SUM.DBF
40 ............... DATABASE: QUONOTES.DBF
41 ............... DATABASE: QUOTES.DBF
42 ............... DATABASE: QUOTESD.DBF
42 ............... DATABASE: REC.DBF
43 ............... DATABASE: RECEIPTS.DBF
43 ............... DATABASE: RECHECK.DBF
44 ............... DATABASE: REGISTER.DBF
45 ............... DATABASE: ROLL90.DBF
45 ............... DATABASE: SALES.DBF
46 ............... DATABASE: SALESPER.DBF
46 ............... DATABASE: SERIALNO.DBF
46 ............... DATABASE: SHIPPER.DBF
47 ............... DATABASE: SHIPTOS.DBF
47 ............... DATABASE: SO.DBF
47.1............... DATABASE: TAXCODE.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-1991, TJS LAB
Table of Contents Continued...
Page Subject
──── ───────────────────────────────────────
47.1............... DATABASE: TCHECKS.DBF
48 ............... DATABASE: TEMPLATE.DBF
48 ............... DATABASE: TERMS.DBF
48 ............... DATABASE: TOPCUS.DBF
49 ............... DATABASE: TYPE.DBF
49 ............... DATABASE: VENDORS.DBF
50 ............... DATABASE: WAREHOUS.DBF
50 ............... DATABASE: WARENAME.DBF
50 ............... DATABASE: WO_NOTES.DBF
51 ............... DATA DICTIONARY
62 ............... QUIRKS
63 ............... CREDITS
63 ............... SUGGESTIONS
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 1
■ INTRODUCTION
The purpose of this document is to give you a general overview of the
entire DAYO Business System.
DAYO is a collection of multiuser business applications that provide a
means of managing inventory, purchasing, invoicing, customers, vendors,
sales and more... All DAYO products are multiuser, designed to work on a
Microcomputer (PC) Based Local Area Network (LAN), like Novell (tm). DAYO
can, however, be used in a 'standalone' mode; running on a single PC.
DAYO is full featured with features being added frequently. Unlike many
'off the shelf' products, DAYO is dynamic; constantly evolving into that
'perfect' program. Version numbers are used (ie: Version 2.0), but not to
designate a static/fixed program. Version 1.3 changed the next day to Version
1.3+ and maybe tomorrow we will call it Version 1.3++ or 1.4... The point
being that you get the latest product available or if registered, the ability
to upgrade frequently to the latest release. The positive 'trade-offs' for
this are that you can procure the software inexpensively since TJS LAB does
not have to pay a fortune in developmental costs before a product is
released. You also get the 'latest and greatest' product that may even
include a suggested change by you. Negatively, you may experience a 'bug' not
found before a product was released. We do fix reported 'bugs' (we like to
call them 'features') free and will (at our cost) mail out or send via modem
the fix (usually the same day). We do not supply printed manuals (another
reason for a low cost since they total over 3000 pages), but do supply them
in a 'ready to print' format so that you can create your own manuals. Note,
all user manual documents can be read on the screen with the F1 (Help)
function key. Like the programs, user manuals also change frequently...
DAYO Business Applications grow with your company. The ability to
upgrade your system is available with the addition of other DAYO products.
Source to DAYO is also available, allowing you to make further modifications
and enhancements. DAYO Clock was written with Qbasic (tm); all others were
written with Clipper (tm).
Current Modules:
Inventory Back Orders Smart Reports
Point of Sale Accounts Receivable Materials Requirement Planning
Price Book Accounts Payable Menu
Quotes General Ledger Clock
Index Look Up Databases Payroll
Passwords End of Period/Purge Update & Conversion
Time & Billing Bar Code
DAYO was created by TJS LAB, a Software Publishing & Computer Consulting
Company based in Orlando Florida. Support and customizing of DAYO is a major
function of TJS LAB.
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 2
DAYO is comprised of many programs (called modules) that perform a
particular function. For example, DAYO Inventory provides a mechanism for
the maintenance of inventory items, vendors, purchase orders, and the
receiving of purchase orders. DAYO Point of Sale (POS) is a module that
creates invoices. Accounts Receivable (AR) is the module that maintains
receivables (what your customers owe you). Note, all the modules are
described in more detail later in this document.
All the modules were created to be TOTALLY INTEGRATED with each other,
however, they can be used independently as well.
DAYO is a MULTIUSER system. This means that when run on a network (like
Novell (tm)), the databases and files can be shared; used simultaneously by
more than one user. If used on a network, no changes are required for DAYO.
The network may have to be 'told' to mark all DAYO files as
sharable/read/write...
There are hundreds of reports for DAYO. Each module has many reports and
specific to itself and DAYO Smart Reports contains many other reports.
DAYO uses databases, report forms, and configuration files that are
dBase III+/IV (tm) compatible. This means you can use the popular dBase
programs to edit, view, and report on data from the many DAYO databases.
Complete documentation is available for every module, and is usually
found in the same compressed distribution diskette/program. Some modules are
so large that the documentation is supplied by itself (ie: DAYO POS). DAYO
documents total over 5 megabytes (over 3000 pages)! We suggest you print
the documents out yourself (they are pre-formatted to print at 6 lines per
inch at less than 60 lines per page), or just view them using the F1 (Help)
key function. For best printing results, use 3-hole, pre-punched paper on a
laser printer (for those of you having one...) and placing the printed pages
in a 3-hole binder.
DAYO is a relational database system. This means that at many points in
the applications, many databases are opened. The databases are 'tied
together' to one another based on control fields (like the ITEM, INVOICE,
and/or the CUSTOMER numbers). To facilitate this, many indexes are created
and maintained. The indexes also perform instantaneous look ups of records
while using DAYO.
A simple database management module is included with most of the modules
to provide you with additional means to modify, view, and report your data.
DAYO places NO LIMITATIONS on the number of records, or users.
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 3
DAYO is a dynamic system, constantly being upgraded and enhanced. New
modules are added frequently. Upgrades are free and should be requested at
least every 90 days to insure you have the 'latest and greatest'... Major
upgrades will be announced via notices to all registered users. Currently
(as of 14 May 1991) the latest release of DAYO is called 'Version 2.0+'.
■ REQUIREMENTS:
* IBM or Compatible CPU with 640K memory
Because DAYO uses much of 'DOS' memory, it is recommended that
no TSR (memory resident) programs be loaded.
* DOS 3.3 or above (Will NOT work under any earlier version!)
* Printer(s) (DAYO supports HP (tm) compatible printers...)
* Hard disk with plenty of available space (especially if all DAYO
modules are to be used). The general rule for estimating the
required amount of disk space for most of the modules is:
- Approximately 1 Meg (1,000,000 bytes), available disk space
for each major DAYO module -
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved by
TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. An exception to this rule is the
making of backup copies of registered software disks. No RESALE of any part
of the source codes is authorized without the prior written consent of
TJS LAB. TJS LAB retains all rights to all DAYO modules, documentation, and
source codes.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS". TJS LAB will not be
liable for any damage done to your data, hardware and/or software systems
as a result of using any DAYO module.
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 4
■ SETUP & OPERATION
There are 2 means of installing DAYO on your hard disk:
1st - SETUP.EXE (Supplied with registrations)
A SETUP program was created to aid/perform the task of installation,
and can be found on the latest release of the DAYO MENU diskette.
It is recommended that this program be used, especially when the
entire DAYO system is being installed. DAYO SETUP will prompt you
to insert your DAYO diskettes, and then perform the task of creating
directories and coping the files from the diskettes to your hard
disk. After running SETUP, run MENU.BAT from the \DAYO directory.
Enter/select each of the modules from the menu. If the module is
present and all works well, the initial entry into a module will
initiate the self extracting process and/or the creation of all
database, index and configuration files.
2nd - Manually - Using DOS - By Yourself (ie: from a BBS download)
The installation of a single DAYO module is relatively simple. Copy,
the contents of the DAYO floppy disk into a directory on your hard
disk (ie: \DAYOINV). UnZip the module or run the Self Extracting
file. Repeat this process for each DAYO module. After coping and
extracting all file, run MENU.BAT from the \DAYO directory.
Enter/select each of the modules from the menu. If the module is
present and all works well, the initial entry into a module will
initiate the creation of all database, index and configuration
files.
IT IS HIGHLY RECOMMENDED THAT EACH DAYO MODULE HAVE ITS OWN DIRECTORY:
\DAYOINV\ (for Inventory)
\DAYOPOS\ (for Point of Sale, 'Little' & Rental POS)
\DAYOTB\ (for Time & Billing)
\DAYOBO\ (for BackOrders)
\DAYOPB\ (for Price Books)
\DAYOQUO\ (for Quotes)
\DAYOAR\ (for Accounts Receivable)
\DAYOGL\ (for General Ledger)
\DAYOPAY\ (for Payroll)
\DAYOLU\ (for Database LookUp)
\DAYOAP\ (for Accounts Payable)
\DAYOEOP\ (for End of Period/Purge)
\DAYORPT\ (for Smart Reports)
\DAYOMRP\ (for Materials Requirement Planning)
\DAYOPAS\ (for Passwords)
\DAYOBAR\ (for Bar Codes)
\DAYOX\ (for Indexing)
\DAYOORD\ (for Order Entry)
\DAYOLOG\ (for Shipping Log)
\DAYOMEM\ (for Membership)
\DAYO\ (for Menu)
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 5
The DAYO Menu program/batch file (MENU.BAT) has these directories in it,
and will require editing if you decide to place the DAYO modules elsewhere.
The DOS command to create a new directory is MKDIR (or just MD). This
must be done from the root directory of your hard disk.
After all modules have created their databases, index and configuration
files, go to and edit each configuration option in every module.
■ HOME DIRECTORIES FOR THE DATABASES
Every database is 'assigned' a DAYO module/directory as its 'home base'.
Knowing the location of the databases is crucial to integration of all the
modules. For example, to make all modules use the same customer database
(CUSTOMER.DBF), the 'CUSTOMER DATABASE LOCATION' option must be correctly
set in the Configuration Menu of each module that uses that database.
\DAYO\ (Update Program)
\DAYO\ (Menu)
\DAYO\ (Clock)
DAYOHELP.DBF
DAYOMENU.DBF
PDRIVER.DBF
\DAYOAP\ (Accounts Payable)
CFORMAT.DBF
CHECKS.DBF
EXPENSES.DBF
DEPOSITS.DBF
ACCOUNTS.DBF
APD.DBF
APH.DBF
TCHECKS.DBF
RECHECK.DBF
\DAYOAR\ (Accounts Receivable)
WO_NOTES.DBF
SHIPTOS.DBF
CUSTMEMO.DBF
SALESPER.DBF
RECEIPTS.DBF
APPLIED.DBF
ARJ.DBF
ARH.DBF
ARD.DBF
TOPCUS.DBF
CUSTOMER.DBF
CUSTMEMO.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 6
HOME DIRECTORIES FOR THE DATABASES Continued...
\DAYOBO\ (BackOrders)
ALLOCATE.DBF
BO.DBF
\DAYOEOP\ (End of Period/Purge)
PHYINV.DBF
LASTINV.DBF
\DAYOINV\ (Inventory)
WAREHOUS.DBF
INVADJ.DBF
VENDORS.DBF
POD.DBF
POH.DBF
REC.DBF
WARENAME.DBF
INV.DBF
\DAYOGL\ (General Ledger)
GLPERIOD.DBF
ROLL90.DBF
GLHIST.DBF
GLTABLED.DBF
GLTABLEH.DBF
GLDEPT.DBF
GLCLASS.DBF
GLTRANS.DBF
GL.DBF
\DAYOLU\ (Database LookUp)
LOOKUP.DBF
\DAYOMRP\ (Materials Requirement Planning)
SO.DBF
BOM.DBF
\DAYOPB\ (Price Books)
PB.DBF
\DAYOPAY\ (Payroll)
PAYHIST.DBF
PAY.DBF
PAYROLL.DBF
PAYNOTES.DBF
PAY_SUM.DBF
QTR_SUM.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 7
HOME DIRECTORIES FOR THE DATABASES Continued...
\DAYOPOS\ (Point of Sale)
INVOICE.DBF
TAXCODE.DBF
TYPE.DBF
TERMS.DBF
SHIPPER.DBF
REGISTER.DBF
DETAIL.DBF
TEMPLATE.DBF
SERIALNO.DBF
\DAYOQUO\ (Quotes)
QUOTES.DBF
QUOTESD.DBF
QUONOTES.DBF
\DAYORPT\ (Smart Reports)
SALES.DBF
\DAYOTB\ (Time & Billing)
PROJECTS.DBF
\DAYOX\ (Indexing)
DAYOX.DBF
\DAYOORD\ (Order Entry)
ORDERS.DBF
ORDERSD.DBF
\DAYOLOG\ (Shipping Log)
LOGHEAD.DBF
LOGDET.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 8
■ DAYO APPLICATIONS
■ INVENTORY
DAYO Inventory is a Multiuser Inventory Control, Purchasing, and Vendor
Maintenance application. Use DAYO Inventory to create and maintain an
inventory of any product. Create and print purchase orders on a standard
printer or a Hewlett Packard LaserJet (tm). Receive purchase orders into
inventory, with the option of printing receivers ('key recs'), and inventory
tags/price labels. Maintain a vendors database complete with the vendors
purchasing history. With the exception of the initial and ongoing data entry
of new product and vendors, DAYO Inventory is totally menu driven. Other
features include Reports, Labels, Lists, and a Graph. A simple database
management module is also included to provide you with additional means to
modify, view, and report your data.
■ POS and 'Little' POS
DAYO POS (Point of Sale) is a Billing and Invoicing application for any
size business. It is the DAYO module that permits you to invoice your
products while keeping an accurate record of all your 'sales'. Features
include: Multiuser (ie: Novell), Registers, Quote Interface (to DAYO
Quotes), Templates Back Orders, Data Entry Validation, Cash Drawers (Serial
or Parallel), Databases are dBase (tm) compatible, HP Laser Special
Invoices, Preprinted Invoices, Standard Invoices, Packing/Shipping Lists,
Customer Ship To/Mailing Address Labels, Sales Graphs, Special Customer
Pricing ( Margin, Discount Off List, Fixed), Sales Tax Codes, Terms Codes,
Invoice Type Codes, Shippers/Method of Shipment Codes, Credit Limits,
Passwords (with DAYO Passwords), and many Reports.
■ PRICE BOOK
DAYO Price Book is a system of creating and maintaining specialized
pricing for your customer/clients. Special printouts (Price Books/Catalogs)
may be printed to a standard printer, or to a Hewlett Packard (tm) Laserjet
or compatible. It requires the presence of DAYO Inventory and DAYO POS
(Point of Sale) programs/databases.
Customers are invoiced (with DAYO POS), using the price in the inventory
database (INV.DBF), or with one of the special Price Book methods:
Fixed - Fixed Price for a Unique Item + Customer (1st Priority)
Margin - 'Cost Plus' (2nd Priority)
List Discount - Discount off the List/Retail Price (3rd Priority)
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 9
■ QUOTES
DAYO Quotes creates sales order quotes based on the DAYO Inventory,
Customer, and other DAYO databases. Quotes can be printed on a standard
printer or a Hewlett Packard (tm) Laserjet compatible printer. The quote can
be printed on a pre-printed form, on the Laser printer in a special laser
format, or as a standard/default form. DAYO Quotes closely models itself
after the DAYO POS (Point of Sale) application and is totally integrated
with that application. Templates (kits or bundles), are supported.
■ INDEX
DAYO INDEX is a program designed to manage the indexing of the DAYO
databases. DAYO applications all have multiple indexes, and because it is
recommended that they be reindexed at least once daily (ie: just after
midnight), DAYO Index was created to simplify this process.
■ PASSWORDS
DAYO PASSWORDS provide DAYO Business Application users with a system of
database security through the use of passwords. Its use is optional, but
recommended in areas where more than one person has access to the data.
■ DAYO BACK ORDERS
DAYO BACK ORDERS is the maintenance module for the processing of all
your customers/sales backorders. DAYO BO (working with DAYO POS) determines
and manages the filling (allocation) of your customers backorders. It does
this through an allocation process that determines what backordered items
are 'fillable' because of receipts into the inventory. Back Orders create
the same type invoices as DAYO POS.
■ AR (ACCOUNTS RECEIVABLE)
DAYO AR is the 'final chapter' to the processing and maintenance of all
your Receivables. DAYO AR includes routines to handle cash receipts,
customers, invoice types, terms, taxcodes, sales persons, and more. Many
reports are included (ie: Ageing, Customer, Sales...). There is a routine
to print Statements (ie: SMART, 90, 60, 30 days), and another one to create
and print 'non' standard invoices (not applicable to DAYO POS). HP Laser
forms are provided as an option for Statements and Invoices.
■ AP (ACCOUNTS PAYABLE)
DAYO AP is the 'final chapter' to the processing and maintenance of all
your Payables. DAYO AP's key mission is to process/post your purchase orders,
however, many other routines have been provided, ie: Expense Maintenance,
1099 MISC Forms, Purchase Clearing, Vendor Maintenance, Hand/Manual Checks,
Batch Checks, Recurring Checks, Unlimited Bank Accounts, Unlimited Check
Printing Formats and over 21 Reports.
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 10
■ GL (GENERAL LEDGER)
DAYO General Ledger provides a means to manage and report company
finances. DAYO GL is totally integrated with the other DAYO packages.
Features include computer generated posting, multiuser, double entry, export
Data, 30+ reports, budget management and unlimited accounts.
■ LOOK UP
DAYO Look Up is a routine for DAYO users to view data from any DAYO
database or dBase (tm) compatible database (.DBF). No editing is allowed.
This provides a 'safe' tool for users that do not have the need to make
changes to the databases. Look Up has multi-level passwords.
■ DAYO EOP
DAYO EOP (End of Period Pack & Inventory) contains routines that are
normally run at the end of a reporting period (ie: Month). DAYO EOP permits
you to permanently remove deleted records from the Accounts Receivable (AR)
and Accounts Payable (AP) databases, and to erase old report text files.
There is also a routine for performing a Physical Inventory. Many reports
are included (ie: AR Ageing, AP Summary, Inventory Movement).
■ DAYO SMART REPORTS
DAYO SMART REPORTS contain many reports/routines that will help you
manage your purchasing, inventory, invoices, backorders, sales, and your
databases. There are 60+ Reports/Lists/Routines included in Smart Reports,
ie: Single Warehouse, Inventory Zero Price, Valuation Expanded, Inventory
Zero Retail, ReOrder (2 weeks), ReOrder (4 weeks), ReOrder (8 weeks),
Negative Onhand, StockLevel Shortage, Vendor List, StockLevel Over, Customer
List, Inventory ASCII Text, Inventory Item List, Late PO, Checking Account
List, PO - Due In This Week, Check Format List, Inventory Zero Cost, and an
Expenses List.
■ MENU
DAYO MENU is a simple DOS level menu system for use with the DAYO line
of Business Applications. Many features are available as menu options,
ie: 18 screen fonts, 25, 43, or 50 lines per page, system statistics, view
user manuals, and more.
■ CLOCK
DAYO CLOCK is a simple Clock display and optional alarm, that can act
as a simple job scheduler.
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 11
■ MRP (MATERIALS REQUIREMENT PLANNING)
DAYO Materials Requirement Planning (MRP) is a module designed for use
by manufacturers or anyone that 'builds' items from other items in their
inventory. DAYO MRP provides you with a method of building items (ENDITEMS)
from other items. This module is totally integrated with DAYO Inventory and
other DAYO modules.
The MRP process starts with the defining of the Bill of Materials (BOM)
for an ENDITEM. After defining the BOM, you can 'build' the new item from
items in the inventory database INV.DBF (if the items are available).
The MRP process takes quantity from the inventory database and places it
in the Work in Process (WIP) quantity fields in the database BOM.DBF. When
enough of every sub component to an ENDITEM is obtained, the process will
produce the ENDITEM which can in turn be placed into the inventory
database.
■ PAYROLL
DAYO Payroll provides a system for the computation of payroll for
businesses of any size. DAYO Payroll contains many features and functions
not normally found in any PC payroll application. Some of DAYO payroll's
features include: Multiuser, unlimited employees, Weekly, BiWeekly, and/or
Monthly payrolls, quarterly, year to date (YTD), and current summary
databases, databases are dBase (tm) compatible, Automatic payroll posting &
computation, vacation maintenance, sick pay/days maintenance, check printing,
multiple states, standard or fixed state tax, standard or fixed federal tax,
SDI tax, overtime & premium hourly wages, up to 8 deductions, exempt/non-
exempt deductions, view reports on screen, printer setup & drivers, over
25+ configurable options, and many reports.
■ TIME & BILLING
DAYO Time & Billing (the single largest module) comprises a system of
creating invoices for services and/or products. DAYO Time & Billing is
contains many features and functions found in many of the other DAYO modules.
It has support for an inventory, receivables, projects/jobs/cases, and
customers/clients. Other features include: multiuser, unlimited customers/
clients, unlimited projects/jobs/cases, project notes, customer notes, 30+
reports, onscreen viewing of reports, databases are dBase (tm) compatible,
laser formats for invoices and statements, 2 styles of statements/bills,
printer setup & drivers, cash drawers, and over 46+ configurable options.
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 12
■ DAYO BAR CODE 3 of 9
DAYO BAR CODE prints 3 of 9 bar codes onto an Epson (tm) or IBM (tm)
compatible dot matrix printer. It is integrated with the DAYO Inventory and
the DAYO Customer databases. It can be used as a standalone application if
you just have a limited number of labels to print, or have no use for an
inventory control or accounts receivable application. Labels are printed onto
standard labels (3.5 by 15/16 inches at 6 lines per inch). The inventory bar
code label consists of an item number, its bar code, with the option to also
print the vendor item number, description, unit of issue, weight, and
bin/location. The customer bar code label consists of a customer number, its
bar code, with the option to also print the customer's name and telephone
number.
■ DAYO MEMBERSHIP
DAYO Membership is an application designed to track membership for an
association or organization. The ability to maintain records for donations,
dues, payments and/or invoices has also been incorporated into the package.
Use DAYO Membership to record member information and optionally, maintain a
simple accounting system for dues and/or donations.
Many reports and reporting routines are included in this package, ie:
Members List #1, Members List #2, Members Expanded #1, Members Expanded #2,
Members Expanded #3, Ageing, Notes (Member), Dump (Complete Data),
Receipts Statements, Folder Labels, Labels (Standard), Big Labels,
Payments, Form Letters, Browse Invoices, Invoices, Config Status, View
Reports On Screen, and Printer Setup.
■ DAYO ORDER ENTRY
DAYO Orders creates sales orders based on the DAYO Inventory,
Customer, and other DAYO databases. Orders can be printed on a standard
printer or a Hewlett Packard (tm) Laserjet compatible printer. The order can
be printed on a pre-printed form, on the Laser printer in a special laser
format, or as a standard/default form.
■ DAYO SHIPPING LOG
DAYO Shipping Log records all invoices/goods shipped.
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 12.1
■ DAYO RENTAL POS
DAYO RENTAL POS (Point of Sale) is a Billing and Invoicing application
for any business that rents items, equipment, or services, ie: Videos,
Tapes, Furniture, Tools, Appliances, etc. This program requires the regular
DAYO POS module for its reports and configuration settings. It is by default
a multiuser system, allowing almost unlimited numbers of users to have the
ability to simultaneously invoice using this one program on a PC based
LAN/Network. It can however, be run (like all DAYO products) as a
'standalone' application.
■ UPDATE & CONVERSION
DAYO UPDATE is a program created to update and convert earlier versions
of DAYO databases and memory files. * It is required when attempting to
upgrade any DAYO module. *** It is NOT necessary for anyone installing DAYO
for the first time!
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 12.2
DAYO BUSINESS APPLICATIONS REGISTRATION COSTS
Prices Effective as of 14 March 1991
DAYOIE DAYO Inventory Registration & Program............ 25.00 _____
DAYOPE DAYO POS Registration & Program.................. 25.00 _____
DAYOPS DAYO 'LITTLE POS Registration & Program.......... 25.00 _____
DAYOBE DAYO PB Registration & Program.................. 25.00 _____
DAYOQE DAYO Quotes Registration & Program............... 25.00 _____
DAYOXE DAYO Index Registration & Program................ 25.00 _____
DAYOIDE DAYO Password Registration & Program............. 25.00 _____
DAYOOE DAYO Back Order Registration & Program........... 25.00 _____
DAYOAE DAYO Accounts Receivable Registration & Program.. 25.00 _____
DAYOVE DAYO Accounts Payable Registration & Program..... 25.00 _____
DAYOLE DAYO Look Up Registration & Program.............. 25.00 _____
DAYOEE DAYO End of Period/Purge Registration & Program.. 25.00 _____
DAYORE DAYO Smart Reports Registration & Program........ 25.00 _____
DAYOME DAYO Menu Registration & Program................. 25.00 _____
DAYOCLOK DAYO Clock Registration & Program................
(Includes Source License)
DAYOUPDT Update & Conversion Program......................
STARTER ** Registration for Inventory, POS, AR, AP, Smart
Reports and Menu 99.00 _____
EXTRAS ** Registration for Quotes, Index, End of Period,
Look Up, and Price Books 99.00 _____
DAYOPACK ** Registration for Basic DAYO Modules (All above).. 235.00 _____
ADD-ONS - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
DAYOWE DAYO Materials Requirement Planning (MRP)........ 50.00 _____
Program & Registration
DAYOYE DAYO Payroll Registration & Program.............. 25.00 _____
DAYOGE DAYO General Ledger (GL) Program & Registration.. 50.00 _____
DAYO39 DAYO Bar Code Registration & Program............. 25.00 _____
DAYOTE DAYO Time & Billing.............................. 50.00 _____
DAYODE DAYO Membership.................................. 50.00 _____
DAYOPR DAYO Rental POS Registration & Program........... 25.00 _____
DAYODE DAYO Order Entry Registration & Program.......... 25.00 _____
DAYOSE DAYO Shipping Log Registration & Program......... 25.00 _____
OTHER PRODUCTS - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
BRAIN Batch Routine & Menu............................. 50.00 _____
(Source Code NOT Available)
KISBILL Keep It Simple Billing & Invoicing............... 25.00 _____
KISBILLS KISBILL Source Code ............................. 300.00 _____
Total: _____
Remember we make changes at a very reasonable rate!
Terms: Check, Money Order or C.O.D. only
Name: _______________________________ Mail To:
Address: _______________________________ TJS LAB
_______________________________ Attn: SALES
_______________________________ P.O. Box 585366
Orlando, Florida 32858-5366
(407) 291-3960
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 13
■ DATABASE STRUCTURES (AS OF 1 MARCH 1991)
The following are the latest database structures for ALL the DAYO
databases. Note, the structures change frequently as does the addition of
new databases (ie: the release of a new DAYO module).
■ DATABASE: ACCOUNTS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NUMBER Character 2 1 2
2 NAME Character 30 3 32
3 ACCTNUM Character 20 33 52
4 BALANCE Numeric 10 2 53 62
5 ADDR1 Character 30 63 92
6 ADDR2 Character 30 93 122
7 CITY Character 22 123 144
8 STATE Character 2 145 146
9 ZIP Character 10 147 156
10 PHONE Character 14 157 170
11 TYPE Character 3 171 173
12 DATE Date 8 174 181
13 LASTDATE Date 8 182 189
14 LDEPOSIT Numeric 10 2 190 199
15 CLASS Character 3 200 202
16 TRANSACT Character 12 203 214
═════
Total 215
■ DATABASE: ALLOCATE.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 INVOICE Numeric 6 1 6
2 BO Numeric 6 7 12
3 ITEM Character 12 13 24
4 DESC Character 30 25 54
5 QTY Numeric 7 55 61
6 BOQTY Numeric 7 62 68
7 PRICE Numeric 10 2 69 78
8 COST Numeric 10 2 79 88
9 TAXABLE Logical 1 89 89
10 DATE Date 8 90 97
11 TIME Character 8 98 105
12 PAY Logical 1 106 106
13 RECNO Numeric 7 107 113
14 CUSTOMER Numeric 6 114 119
15 CLASS Character 3 120 122
═════
Total 123
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 14
■ DATABASE: APD.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 JOURNAL Numeric 6 1 6
2 PO Numeric 6 7 12
3 VENDOR Character 10 13 22
4 ITEM Character 12 23 34
5 DESC Character 30 35 64
6 VENDITEM Character 12 65 76
7 QUANTITY Numeric 7 77 83
8 COST Numeric 10 2 84 93
9 DATE Date 8 94 101
10 TYPE Character 3 102 104
11 CLASS Character 3 105 107
12 OPEN Logical 1 108 108
13 TAXABLE Logical 1 109 109
14 KEY Numeric 6 110 115
15 RECDATE Date 8 116 123
16 TAXABLE Logical 1 124 124
17 TRANSACT Character 12 125 136
═════
Total 137
■ DATABASE: APH.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 JOURNAL Numeric 6 1 6
2 PO Numeric 6 7 12
3 VENDOR Character 10 13 22
4 NAME Character 30 23 52
5 ATTN Character 30 53 82
6 ADDR1 Character 30 83 112
7 ADDR2 Character 30 113 142
8 CITY Character 22 143 164
9 STATE Character 2 165 166
10 ZIP Character 10 167 176
11 PHONE Character 14 177 190
12 TYPE Character 3 191 193
13 DATE Date 8 194 201
14 PODATE Date 8 202 209
15 TERMS Character 20 210 229
16 SHIPPER Character 20 230 249
17 BY Character 5 250 254
18 PRINTED Logical 1 255 255
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 15
DATABASE: APH.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
19 KEY Numeric 6 256 261
20 OPEN Logical 1 262 262
21 SUBTOTAL Numeric 10 2 263 272
22 TAXES Numeric 10 2 273 282
23 ADJUST Numeric 10 2 283 292
24 FREIGHT Numeric 10 2 293 302
25 PAID Numeric 10 2 303 312
26 AMOUNT Numeric 10 2 313 322
27 PC Logical 1 323 323
28 CHECKNO Character 12 324 335
29 COMMENT Character 50 336 385
30 CLASS Character 3 386 388
31 PAYDATE Date 8 389 396
32 TRANSACT Character 12 397 408
33 SHIPNAME Character 30 409 438
34 SHIPADDR1 Character 30 439 468
35 SHIPADDR2 Character 30 469 498
36 SHIPCITY Character 22 499 520
37 SHIPSTATE Character 2 521 522
38 SHIPZIP Character 10 523 532
39 SHIPPHONE Character 14 533 546
40 RECDATE Date 8 547 554
═════
Total 555
■ DATABASE: APPLIED.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 JOURNAL Numeric 6 1 6
2 INVOICE Numeric 6 7 12
3 PROJECT Numeric 6 13 18
4 AMOUNT Numeric 10 2 19 28
5 DATE Date 8 29 36
Total 37
■ DATABASE: ARJ.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 JOURNAL Numeric 6 1 6
═════
Total 7
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 16
■ DATABASE: ARH.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 INVOICE Numeric 6 1 6
2 CUSTOMER Numeric 6 7 12
3 SHIPNAME Character 30 13 42
4 SHIPADDR1 Character 30 43 72
5 SHIPADDR2 Character 30 73 102
6 SHIPCITY Character 17 103 119
7 SHIPSTATE Character 2 120 121
8 SHIPZIP Character 10 122 131
9 PHONE Character 14 132 145
10 TYPE Character 3 146 148
11 TERMS Character 20 149 168
12 TERMS2 Character 20 169 188
13 AMOUNT2 Numeric 10 2 189 198
14 SHIPPER Character 20 199 218
15 DATE Date 8 219 226
16 TIME Character 8 227 234
17 REG Character 3 235 237
18 BY Character 30 238 267
19 SALESPER Character 3 268 270
20 CUST_PO Character 15 271 285
21 SC Logical 1 286 286
22 BO Numeric 6 287 292
23 TAXRATE Numeric 6 4 293 298
24 TAXCODE Character 3 299 301
25 TAXES Numeric 10 2 302 311
26 ADJUST Numeric 10 2 312 321
27 FREIGHT Numeric 10 2 322 331
28 SUBTOTAL Numeric 10 2 332 341
29 OPEN Logical 1 342 342
30 PRINTED Logical 1 343 343
31 CLASS Character 3 344 346
32 PAID Numeric 10 2 347 356
33 DISCOUNT Numeric 10 2 357 366
34 COMMENT Character 50 367 416
35 POSTDATE Date 8 417 424
36 TRANSACT Character 12 425 436
═════
Total 437
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 17
■ DATABASE: ARD.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 INVOICE Numeric 6 1 6
2 ITEM Character 12 7 18
3 DESC Character 30 19 48
4 QTY Numeric 7 49 55
5 PRICE Numeric 10 2 56 65
6 COST Numeric 10 2 66 75
7 TAXABLE Logical 1 76 76
8 DATE Date 8 77 84
9 CLASS Character 3 85 87
10 CUSTOMER Numeric 6 88 93
11 POSTDATE Date 8 94 101
12 TRANSACT Character 12 102 113
═════
Total 114
■ DATABASE: BO.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 INVOICE Numeric 6 1 6
2 ITEM Character 12 7 18
3 DESC Character 30 19 48
4 QTY Numeric 7 49 55
5 FILLED Numeric 7 56 62
6 PRICE Numeric 10 2 63 72
7 COST Numeric 10 2 73 82
8 TAXABLE Logical 1 83 83
9 DATE Date 8 84 91
10 PAY Logical 1 92 92
11 TIME Character 8 93 100
12 CUSTOMER Numeric 6 101 106
13 CLASS Character 3 107 109
═════
Total 110
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 18
■ DATABASE: BOM.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 ENDITEM Character 12 1 12
2 DESC Character 30 13 42
3 COST Numeric 10 3 43 52
4 LEVEL1 Character 12 53 64
5 LEVEL2 Character 12 65 76
6 LEVEL3 Character 12 77 88
7 LEVEL4 Character 12 89 100
8 LEVEL5 Character 12 101 112
9 LEVEL6 Character 12 113 124
10 LEVEL7 Character 12 125 136
11 LEVEL8 Character 12 137 148
12 BUILD_QTY Numeric 10 3 149 158
13 FINIS_QTY Numeric 10 3 159 168
14 OPEN_QTY Numeric 10 3 169 178
15 WIP_QTY Numeric 10 3 179 188
16 REQ_QTY Numeric 10 3 189 198
17 PER_QTY Numeric 10 3 199 208
18 PTD_QTY Numeric 10 3 209 218
19 YTD_QTY Numeric 10 3 219 228
20 DATE Date 8 229 236
21 LASTDATE Date 8 237 244
22 LASTTIME Character 8 245 252
23 HOURS Numeric 10 3 253 262
24 LABOR Numeric 10 3 263 272
25 LABOR1 Numeric 10 3 273 282
26 LABOR2 Numeric 10 3 283 292
27 OVERRIDE Logical 1 293 293
28 POSITION Character 7 294 300
═════
Total 301
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 18.1
■ DATABASE: CFORMAT.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CFORMAT Character 2 1 2
2 NAME Character 30 3 32
3 SETUP Character 50 33 82
4 C_LENGTH Numeric 2 83 84
5 C_WIDTH Numeric 3 85 87
6 V_1ST_LINE Numeric 2 88 89
7 V_END_LINE Numeric 2 90 91
8 V_LCOLUMN Numeric 2 92 93
9 V_RCOLUMN Numeric 3 94 96
10 WORD_ROW Numeric 2 97 98
11 WORD_COL Numeric 2 99 100
12 AMOUNT_ROW Numeric 2 101 102
13 AMOUNT_COL Numeric 3 103 105
14 NAME_ROW Numeric 2 106 107
15 NAME_COL Numeric 2 108 109
16 ADDR_ROW Numeric 2 110 111
17 ADDR_COL Numeric 2 112 113
18 CV_NUM_ROW Numeric 2 114 115
19 CV_NUM_COL Numeric 3 116 118
20 DATE_ROW Numeric 2 119 120
21 DATE_COL Numeric 3 121 123
22 FOR_ROW Numeric 2 124 125
23 FOR_COL Numeric 2 126 127
24 CHK_ROW Numeric 2 128 129
25 CHK_COL Numeric 2 130 131
═════
Total 132
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 19
■ DATABASE: CHECKS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CHECKNO Character 12 1 12
2 ACCTNUM Character 20 13 32
3 NUMBER Character 2 33 34
4 AMOUNT Numeric 10 2 35 44
5 NAME Character 30 45 74
6 WHATFOR Character 40 75 114
7 DATE Date 8 115 122
8 JOURNAL Numeric 6 123 128
9 ACCOUNT Character 10 129 138
10 CV Logical 1 139 139
11 TYPE Character 3 140 142
12 CFORMAT Character 2 143 144
13 BY Character 30 145 174
14 CLASS Character 3 175 177
15 TRANSACT Character 12 178 189
16 SUBAMOUNT Numeric 10 2 190 199
═════
Total 200
■ DATABASE: CUSTOMER.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CUSTOMER Numeric 6 1 6
2 NAME Character 30 7 36
3 ATTN Character 30 37 66
4 ADDR1 Character 30 67 96
5 ADDR2 Character 30 97 126
6 CITY Character 22 127 148
7 STATE Character 2 149 150
8 ZIP Character 10 151 160
9 SHIPNAME Character 30 161 190
10 SHIPADDR1 Character 30 191 220
11 SHIPADDR2 Character 30 221 250
12 SHIPCITY Character 22 251 272
13 SHIPSTATE Character 2 273 274
14 SHIPZIP Character 10 275 284
15 PHONE Character 14 285 298
16 SALESPER Character 3 299 301
17 RATE Numeric 10 3 302 311
18 TAXRATE Numeric 6 4 312 317
19 TERMS Character 20 318 337
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 20
DATABASE: CUSTOMER.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
20 SHIPPER Character 20 338 357
21 DATE Date 8 358 365
22 LASTDATE Date 8 366 373
23 TYPE Character 3 374 376
24 CLASS Character 3 377 379
25 PBM Numeric 6 3 380 385
26 PBL Numeric 6 3 386 391
27 SALESPTD Numeric 10 2 392 401
28 SALESYTD Numeric 10 2 402 411
29 DUE Numeric 10 2 412 421
30 PAID_PURC Numeric 10 2 422 431
31 LIMIT Numeric 10 2 432 441
32 ACTIVE Logical 1 442 442
33 TAXCODE Character 3 443 445
34 FAX Character 14 446 459
═════
Total 460
■ DATABASE: CUSTMEMO.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CUSTOMER Numeric 6 1 6
2 NOTES Memo 10 7 16
═════
Total 17
■ DATABASE: DAYOHELP.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 MODULE Character 10 1 10
2 CALLPRG Character 10 11 20
3 HELPVAR Character 10 21 30
4 LASTDATE Date 8 31 38
5 LASTUSER Character 30 39 68
6 HELP_NOTE Memo 10 69 78
═════
Total 79
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 21
■ DATABASE: DAYOMENU.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 PROGRAM Character 15 1 15
2 PROG_NAME Character 12 16 27
3 DESC Character 50 28 77
4 LOCATION Character 40 78 117
5 LASTDATE Date 8 118 125
6 LASTTIME Character 8 126 133
7 NUM_RUNS Numeric 10 134 143
8 PASSWORD Character 7 144 150
═════
Total 151
■ DATABASE: DAYOX.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NAME Character 12 1 12
2 INDEXNAME Character 12 13 24
3 OPERAND Character 40 25 64
4 LOCATION Character 40 65 104
5 LASTDATE Date 8 105 112
6 STARTTIME Character 8 113 120
7 ENDTIME Character 8 121 128
8 OKAYS Numeric 7 129 135
9 FAILURES Numeric 7 136 142
10 DBSIZE Numeric 8 143 150
11 NTXSIZE Numeric 8 151 158
12 NUMRECORDS Numeric 7 159 165
13 ACTIVE Logical 1 166 166
14 MESSAGE Character 30 167 196
═════
Total 197
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 22
■ DATABASE: DEPOSITS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 DEPOSIT Numeric 6 1 6
2 ACCTNUM Character 20 7 26
3 NUMBER Character 2 27 28
4 WHATFOR Character 40 29 68
5 TYPE Character 3 69 71
6 AMOUNT Numeric 10 2 72 81
7 CLASS Character 3 82 84
8 TRANSACT Character 12 85 96
9 DATE Date 8 97 104
10 BY Character 30 105 134
═════
Total 135
■ DATABASE: DETAIL.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 INVOICE Numeric 6 1 6
2 PROJECT Numeric 6 7 12
3 ITEM Character 12 13 24
4 DESC Character 30 25 54
5 QTY Numeric 9 3 55 63
6 PRICE Numeric 10 2 64 73
7 COST Numeric 10 2 74 83
8 TAXABLE Logical 1 84 84
9 DATE Date 8 85 92
10 CUSTOMER Numeric 6 93 98
11 CLASS Character 3 99 101
12 NS Logical 1 102 102
13 TI Logical 1 103 103
═════
Total 104
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 23
*** ENDITEMS.DBF is discontinued! ***
■ DATABASE: ENDITEMS.DBF *** NO LONGER SUPPORTED ***
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 ENDITEM Character 12 1 12
2 DESC Character 30 13 42
3 BUILD_QTY Numeric 7 43 49
4 FINIS_QTY Numeric 7 50 56
5 OPEN_QTY Numeric 7 57 63
6 PTD_QTY Numeric 7 64 70
7 YTD_QTY Numeric 7 71 77
8 DATE Date 8 78 85
9 LASTDATE Date 8 86 93
10 LASTTIME Character 8 94 101
11 COST Numeric 10 2 102 111
12 OVERRIDE Logical 1 112 112
13 MOREDESC Character 50 113 162
═════
Total 163
■ DATABASE: EXPENSES.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 EXPENSE Numeric 6 1 6
2 WHATFOR Character 40 7 46
3 TYPE Character 3 47 49
4 AMOUNT Numeric 10 2 50 59
5 SUBTOTAL Numeric 10 2 60 69
6 TAXES Numeric 10 2 70 79
7 FREIGHT Numeric 10 2 80 89
8 ADJUST Numeric 10 2 90 99
9 CHECKNO Character 12 100 111
10 ACCTNUM Character 20 112 131
11 NUMBER Character 2 132 133
12 CLASS Character 3 134 136
13 TRANSACT Character 12 137 148
14 DATE Date 8 149 156
═════
Total 157
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 24
■ DATABASE: GL.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 GL_ENTRY Character 12 1 12
2 NAME Character 30 13 42
3 PERIOD1 Numeric 12 2 43 54
4 PERIOD2 Numeric 12 2 55 66
5 PERIOD3 Numeric 12 2 67 78
6 PERIOD4 Numeric 12 2 79 90
7 PERIOD5 Numeric 12 2 91 102
8 PERIOD6 Numeric 12 2 103 114
9 PERIOD7 Numeric 12 2 115 126
10 PERIOD8 Numeric 12 2 127 138
11 PERIOD9 Numeric 12 2 139 150
12 PERIOD10 Numeric 12 2 151 162
13 PERIOD11 Numeric 12 2 163 174
14 PERIOD12 Numeric 12 2 175 186
15 PERIOD13 Numeric 12 2 187 198
16 RETAIN Logical 1 199 199
17 RETAINED Numeric 12 2 200 211
18 LAST_BAL Numeric 12 2 212 223
19 BUDGET1 Numeric 12 2 224 235
20 BUDGET2 Numeric 12 2 236 247
21 BUDGET3 Numeric 12 2 248 259
22 BUDGET4 Numeric 12 2 260 271
23 BUDGET5 Numeric 12 2 272 283
24 BUDGET6 Numeric 12 2 284 295
25 BUDGET7 Numeric 12 2 296 307
26 BUDGET8 Numeric 12 2 308 319
27 BUDGET9 Numeric 12 2 320 331
28 BUDGET10 Numeric 12 2 332 343
29 BUDGET11 Numeric 12 2 344 355
30 BUDGET12 Numeric 12 2 356 367
31 BUDGET13 Numeric 12 2 368 379
32 DR Character 1 380 380
33 CR Character 1 381 381
34 TITLE Logical 1 382 382
35 DATE Date 8 383 390
36 LASTDATE Date 8 391 398
37 ROLL Logical 1 399 399
38 ACCOUNT Character 12 400 411
═════
Total 412
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 25
■ DATABASE: GLCLASS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CLASS Character 3 1 3
2 NAME Character 30 4 33
3 DEBIT Character 12 34 45
4 CREDIT Character 12 46 57
5 DATABASE Character 12 58 69
6 FIELD Character 30 70 99
7 GL_FILTER Character 40 100 139
8 GL_LOGICAL Character 12 140 151
9 DATE Date 8 152 159
═════
Total 160
■ DATABASE: GLDEPT.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NAME Character 30 1 30
2 GLCODE Character 10 31 40
3 DATE Date 8 41 48
═════
Total 49
■ DATABASE: GLHIST.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
2 CLASS Character 3 13 15
3 NAME Character 30 16 45
4 DEBIT Character 12 46 57
5 CREDIT Character 12 58 69
6 AMOUNT Numeric 10 2 70 79
7 DATE Date 8 80 87
8 COMMENT Character 12 88 99
═════
Total 100
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 26
■ DATABASE: GLPERIOD.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 PERIOD Character 30 1 30
2 FROM_DATE Date 8 31 38
3 TO_DATE Date 8 39 46
═════
Total 47
■ DATABASE: GLTABLED.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 GLTAB Numeric 6 1 6
2 SIGN Character 1 7 7
3 GL_ENTRY Character 12 8 19
4 DATE Date 8 20 27
═════
Total 28
■ DATABASE: GLTABLEH.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 GLTAB Numeric 6 1 6
2 NAME Character 30 7 36
3 DATE Date 8 37 44
═════
Total 45
■ DATABASE: GLTRANS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 TRANSACT Character 12 1 12
2 CLASS Character 3 13 15
3 NAME Character 30 16 45
4 DEBIT Character 12 46 57
5 CREDIT Character 12 58 69
6 AMOUNT Numeric 10 2 70 79
7 DATE Date 8 80 87
8 COMMENT Character 12 88 99
═════
Total 100
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 27
■ DATABASE: INV.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 ITEM Character 12 1 12
2 DESC Character 30 13 42
3 ONHAND Numeric 7 43 49
4 TI Logical 1 50 50
5 UNIT Character 3 51 53
6 NS Logical 1 54 54
7 SOLDYTD Numeric 7 55 61
8 SOLDPTD Numeric 7 62 68
9 PRICE Numeric 10 2 69 78
10 COST Numeric 10 2 79 88
11 AVGCOST Numeric 10 2 89 98
12 REALCOST Numeric 10 2 99 108
13 RETAIL Numeric 10 2 109 118
14 ALLOCATED Numeric 7 119 125
15 ONORDER Numeric 7 126 132
16 BO Numeric 7 133 139
17 VENDITEM Character 12 140 151
18 VENDOR Character 10 152 161
19 DATE Date 8 162 169
20 LASTDATE Date 8 170 177
21 STOCKLEVEL Numeric 7 178 184
22 TYPE Character 3 185 187
23 CLASS Character 3 188 190
24 TAXABLE Logical 1 191 191
25 SERIALNO Logical 1 192 192
26 WEIGHT Numeric 8 2 193 200
27 LOCATION Character 3 201 203
═════
Total 204
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 28
■ DATABASE: INVADJ.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 ITEM Character 12 1 12
2 VENDITEM Character 12 13 24
3 QTY Numeric 7 25 31
4 COST Numeric 10 2 32 41
5 PRICE Numeric 10 2 42 51
6 RETAIL Numeric 10 2 52 61
7 DOLLARS Numeric 10 2 62 71
8 REASON Character 30 72 101
9 LOC Character 10 102 111
10 CLASS Character 3 112 114
11 TRANSACT Character 12 115 126
12 BY Character 30 127 156
13 DATE Date 8 157 164
═════
Total 165
■ DATABASE: INVOICE.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 INVOICE Numeric 6 1 6
2 PROJECT Numeric 6 7 12
3 CUSTOMER Numeric 6 13 18
4 SHIPNAME Character 30 19 48
5 SHIPADDR1 Character 30 49 78
6 SHIPADDR2 Character 30 79 108
7 SHIPCITY Character 17 109 125
8 SHIPSTATE Character 2 126 127
9 SHIPZIP Character 10 128 137
10 PHONE Character 14 138 151
11 TYPE Character 3 152 154
12 TERMS Character 20 155 174
13 TERMS2 Character 20 175 194
14 AMOUNT2 Numeric 10 2 195 204
15 SHIPPER Character 20 205 224
16 PROMISED Date 8 225 232
17 DATE Date 8 233 240
18 TIME Character 8 241 248
19 REG Character 3 249 251
20 BY Character 30 252 281
21 SALESPER Character 3 282 284
22 CUST_PO Character 15 285 299
23 SC Logical 1 300 300
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 29
DATABASE: INVOICE.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
24 BO Numeric 6 301 306
25 TAXRATE Numeric 6 4 307 312
26 TAXES Numeric 10 2 313 322
27 ADJUST Numeric 10 2 323 332
28 FREIGHT Numeric 10 2 333 342
29 SUBTOTAL Numeric 10 2 343 352
30 OPEN Logical 1 353 353
31 PRINTED Logical 1 354 354
32 PAID Numeric 10 2 355 364
33 DISCOUNT Numeric 10 2 365 374
34 CLASS Character 3 375 377
35 COMMENT Character 50 378 427
═════
Total 428
■ DATABASE: LOOKUP.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 DATABASE Character 12 1 12
2 NAME Character 30 13 42
3 LOCATION Character 30 43 72
4 PASSWORD Character 7 73 79
5 DATE Date 8 80 87
6 LASTDATE Date 8 88 95
7 COMMENT Character 70 96 165
8 ACCESSES Numeric 8 166 173
9 SIZE Numeric 10 174 183
10 NUMRECORDS Numeric 8 184 191
═════
Total 192
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 30
■ DATABASE: PAY.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NUMBER Character 6 1 6
2 NAME Character 30 7 36
3 SSN Character 11 37 47
4 ADDR1 Character 30 48 77
5 ADDR2 Character 30 78 107
6 CITY Character 20 108 127
7 STATE Character 2 128 129
8 ZIP Character 10 130 139
9 PHONE Character 14 140 153
10 TYPE Character 3 154 156
11 STATUS Character 3 157 159
12 DEPARTMENT Character 3 160 162
13 SEX Character 1 163 163
14 MARITAL Character 1 164 164
15 DOB Date 8 165 172
16 DOH Date 8 173 180
17 RATE Numeric 10 4 181 190
18 PAYPERIOD Character 1 191 191
19 REG_HOURS Numeric 7 3 192 198
20 OT_HOURS Numeric 7 3 199 205
21 P_HOURS Numeric 7 3 206 212
22 OTHER Numeric 10 2 213 222
23 SICK_PAY Numeric 10 2 223 232
24 VAC_PAY Numeric 10 2 233 242
25 WITHHOLD Logical 1 243 243
26 EXEMPTIONS Numeric 2 244 245
27 CURR_RHOUR Numeric 7 3 246 252
28 CURR_OHOUR Numeric 7 3 253 259
29 CURR_PHOUR Numeric 7 3 260 266
30 CURR_RPAY Numeric 10 2 267 276
31 CURR_OPAY Numeric 10 2 277 286
32 CURR_PPAY Numeric 10 2 287 296
33 CURR_OTHER Numeric 10 2 297 306
34 CURR_GROSS Numeric 10 2 307 316
35 CURR_FED Numeric 10 2 317 326
36 CURR_STATE Numeric 10 2 327 336
37 CURR_FICA Numeric 10 2 337 346
38 CURR_SDI Numeric 10 2 347 356
39 CURR_NET Numeric 10 2 357 366
40 CURR_DEDX Numeric 10 2 367 376
41 CURR_DEDN Numeric 10 2 377 386
42 CURR_DED1 Numeric 10 2 387 396
43 CURR_DED2 Numeric 10 2 397 406
44 CURR_DED3 Numeric 10 2 407 416
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 31
DATABASE: PAY.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
45 CURR_DED4 Numeric 10 2 417 426
46 CURR_DED5 Numeric 10 2 427 436
47 CURR_DED6 Numeric 10 2 437 446
48 CURR_DED7 Numeric 10 2 447 456
49 CURR_DED8 Numeric 10 2 457 466
50 CURR_SICK Numeric 10 2 467 476
51 CURR_VAC Numeric 10 2 477 486
52 LAST_CHECK Character 10 487 496
53 CURR_NOTE Character 50 497 546
54 CURR_DATE Date 8 547 554
55 QTR_RHOUR Numeric 10 3 555 564
56 QTR_OHOUR Numeric 10 3 565 574
57 QTR_PHOUR Numeric 10 3 575 584
58 QTR_RPAY Numeric 10 2 585 594
59 QTR_OPAY Numeric 10 2 595 604
60 QTR_PPAY Numeric 10 2 605 614
61 QTR_OTHER Numeric 10 2 615 624
62 QTR_GROSS Numeric 10 2 625 634
63 QTR_FED Numeric 10 2 635 644
64 QTR_STATE Numeric 10 2 645 654
65 QTR_FICA Numeric 10 2 655 664
66 QTR_SDI Numeric 10 2 665 674
67 QTR_NET Numeric 10 2 675 684
68 QTR_DEDX Numeric 10 2 685 694
69 QTR_DEDN Numeric 10 2 695 704
70 QTR_DED1 Numeric 10 2 705 714
71 QTR_DED2 Numeric 10 2 715 724
72 QTR_DED3 Numeric 10 2 725 734
73 QTR_DED4 Numeric 10 2 735 744
74 QTR_DED5 Numeric 10 2 745 754
75 QTR_DED6 Numeric 10 2 755 764
76 QTR_DED7 Numeric 10 2 765 774
77 QTR_DED8 Numeric 10 2 775 784
78 QTR_SICK Numeric 10 2 785 794
79 QTR_VAC Numeric 10 2 795 804
80 YTD_RHOUR Numeric 10 3 805 814
81 YTD_OHOUR Numeric 10 3 815 824
82 YTD_PHOUR Numeric 10 3 825 834
83 YTD_RPAY Numeric 10 2 835 844
84 YTD_OPAY Numeric 10 2 845 854
85 YTD_PPAY Numeric 10 2 855 864
86 YTD_OTHER Numeric 10 2 865 874
87 YTD_GROSS Numeric 10 2 875 884
88 YTD_FED Numeric 10 2 885 894
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 32
DATABASE: PAY.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
89 YTD_STATE Numeric 10 2 895 904
90 YTD_FICA Numeric 10 2 905 914
91 YTD_SDI Numeric 10 2 915 924
92 YTD_NET Numeric 10 2 925 934
93 YTD_DEDX Numeric 10 2 935 944
94 YTD_DEDN Numeric 10 2 945 954
95 YTD_DED1 Numeric 10 2 955 964
96 YTD_DED2 Numeric 10 2 965 974
97 YTD_DED3 Numeric 10 2 975 984
98 YTD_DED4 Numeric 10 2 985 994
99 YTD_DED5 Numeric 10 2 995 1004
100 YTD_DED6 Numeric 10 2 1005 1014
101 YTD_DED7 Numeric 10 2 1015 1024
102 YTD_DED8 Numeric 10 2 1025 1034
103 YTD_SICK Numeric 10 2 1035 1044
104 YTD_VAC Numeric 10 2 1045 1054
105 QUARTER1 Numeric 10 2 1055 1064
106 QUARTER2 Numeric 10 2 1065 1074
107 QUARTER3 Numeric 10 2 1075 1084
108 QUARTER4 Numeric 10 2 1085 1094
109 PRINTED Logical 1 1095 1095
110 DEDUCT1 Character 20 1096 1115
111 DEDUCT1AMT Numeric 10 2 1116 1125
112 DEDUCT1BAL Numeric 10 2 1126 1135
113 DEDUCT1X Logical 1 1136 1136
114 DEDUCT2 Character 20 1137 1156
115 DEDUCT2AMT Numeric 10 2 1157 1166
116 DEDUCT2BAL Numeric 10 2 1167 1176
117 DEDUCT2X Logical 1 1177 1177
118 DEDUCT3 Character 20 1178 1197
119 DEDUCT3AMT Numeric 10 2 1198 1207
120 DEDUCT3BAL Numeric 10 2 1208 1217
121 DEDUCT3X Logical 1 1218 1218
122 DEDUCT4 Character 20 1219 1238
123 DEDUCT4AMT Numeric 10 2 1239 1248
124 DEDUCT4BAL Numeric 10 2 1249 1258
125 DEDUCT4X Logical 1 1259 1259
126 DEDUCT5 Character 20 1260 1279
127 DEDUCT5AMT Numeric 10 2 1280 1289
128 DEDUCT5BAL Numeric 10 2 1290 1299
129 DEDUCT5X Logical 1 1300 1300
130 DEDUCT6 Character 20 1301 1320
131 DEDUCT6AMT Numeric 10 2 1321 1330
132 DEDUCT6BAL Numeric 10 2 1331 1340
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 33
DATABASE: PAY.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
133 DEDUCT6X Logical 1 1341 1341
134 DEDUCT7 Character 20 1342 1361
135 DEDUCT7AMT Numeric 10 2 1362 1371
136 DEDUCT7BAL Numeric 10 2 1372 1381
137 DEDUCT7X Logical 1 1382 1382
138 DEDUCT8 Character 20 1383 1402
139 DEDUCT8AMT Numeric 10 2 1403 1412
140 DEDUCT8BAL Numeric 10 2 1413 1422
141 DEDUCT8X Logical 1 1423 1423
142 USE_SDI Logical 1 1424 1424
143 TAX_STATE Character 2 1425 1426
144 STATE_RATE Numeric 10 4 1427 1436
145 STATE_FIX Numeric 10 2 1437 1446
146 FED_FIX Numeric 10 2 1447 1456
147 FED_FACTOR Numeric 6 4 1457 1462
148 SICK_DAYS Numeric 7 3 1463 1469
149 SICK_USED Numeric 7 3 1470 1476
150 SICK_PER Numeric 7 3 1477 1483
151 VAC_DAYS Numeric 7 3 1484 1490
152 VAC_USED Numeric 7 3 1491 1497
153 VAC_PER Numeric 7 3 1498 1504
154 CLASS Character 3 1505 1507
155 THE_GROSS Numeric 10 2 1508 1517
156 NEXT_KIN Character 50 1518 1567
157 DATE Date 8 1568 1575
158 PARTTIME Logical 1 1576 1576
159 ACTIVE Logical 1 1577 1577
═════
Total 1578
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 34
■ DATABASE: PAYHIST.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NUMBER Character 6 1 6
2 RHOUR Numeric 7 3 7 13
3 OHOUR Numeric 7 3 14 20
4 PHOUR Numeric 7 3 21 27
5 RPAY Numeric 10 2 28 37
6 OPAY Numeric 10 2 38 47
7 PPAY Numeric 10 2 48 57
8 OTHER Numeric 10 2 58 67
9 SICK_PAY Numeric 10 2 68 77
10 VAC_PAY Numeric 10 2 78 87
11 GROSS Numeric 10 2 88 97
12 FED Numeric 10 2 98 107
13 STATE Numeric 10 2 108 117
14 FICA Numeric 10 2 118 127
15 SDI Numeric 10 2 128 137
16 NET Numeric 10 2 138 147
17 LAST_CHECK Character 10 148 157
18 DEDUCT1AMT Numeric 10 2 158 167
19 DEDUCT2AMT Numeric 10 2 168 177
20 DEDUCT3AMT Numeric 10 2 178 187
21 DEDUCT4AMT Numeric 10 2 188 197
22 DEDUCT5AMT Numeric 10 2 198 207
23 DEDUCT6AMT Numeric 10 2 208 217
24 DEDUCT7AMT Numeric 10 2 218 227
25 DEDUCT8AMT Numeric 10 2 228 237
26 DEDX Numeric 10 2 238 247
27 DEDN Numeric 10 2 248 257
28 DATE Date 8 258 265
29 TIME Character 8 266 273
30 CSTATE Character 2 274 275
31 CLASS Character 3 276 278
32 TYPE Character 3 279 281
33 TRANSACT Character 12 282 293
═════
Total 294
■ DATABASE: PAYNOTES.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NUMBER Character 6 1 6
2 NOTES Memo 10 7 16
═════
Total 17
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 35
■ DATABASE: PAYROLL.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NUMBER Character 6 1 6
2 RHOUR Numeric 7 3 7 13
3 OHOUR Numeric 7 3 14 20
4 PHOUR Numeric 7 3 21 27
5 RPAY Numeric 10 2 28 37
6 OPAY Numeric 10 2 38 47
7 PPAY Numeric 10 2 48 57
8 OTHER Numeric 10 2 58 67
9 SICK_PAY Numeric 10 2 68 77
10 VAC_PAY Numeric 10 2 78 87
11 GROSS Numeric 10 2 88 97
12 FED Numeric 10 2 98 107
13 STATE Numeric 10 2 108 117
14 FICA Numeric 10 2 118 127
15 SDI Numeric 10 2 128 137
16 NET Numeric 10 2 138 147
17 LAST_CHECK Character 10 148 157
18 DEDUCT1AMT Numeric 10 2 158 167
19 DEDUCT2AMT Numeric 10 2 168 177
20 DEDUCT3AMT Numeric 10 2 178 187
21 DEDUCT4AMT Numeric 10 2 188 197
22 DEDUCT5AMT Numeric 10 2 198 207
23 DEDUCT6AMT Numeric 10 2 208 217
24 DEDUCT7AMT Numeric 10 2 218 227
25 DEDUCT8AMT Numeric 10 2 228 237
26 DEDX Numeric 10 2 238 247
27 DEDN Numeric 10 2 248 257
28 DATE Date 8 258 265
29 TIME Character 8 266 273
30 CSTATE Character 2 274 275
31 CLASS Character 3 276 278
32 TYPE Character 3 279 281
33 TRANSACT Character 12 282 293
═════
Total 294
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 36
■ DATABASE: PAY_SUM.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 RHOUR Numeric 7 3 1 7
2 OHOUR Numeric 7 3 8 14
3 PHOUR Numeric 7 3 15 21
4 RPAY Numeric 10 2 22 31
5 OPAY Numeric 10 2 32 41
6 PPAY Numeric 10 2 42 51
7 OTHER Numeric 10 2 52 61
8 SICK_PAY Numeric 10 2 62 71
9 VAC_PAY Numeric 10 2 72 81
10 GROSS Numeric 10 2 82 91
11 FED Numeric 10 2 92 101
12 STATE Numeric 10 2 102 111
13 FICA Numeric 10 2 112 121
14 SDI Numeric 10 2 122 131
15 NET Numeric 10 2 132 141
16 LAST_CHECK Character 10 142 151
17 DEDX Numeric 10 2 152 161
18 DEDN Numeric 10 2 162 171
19 LAST_DATE Date 8 172 179
20 LAST_TIME Character 8 180 187
═════
Total 188
■ DATABASE: PB.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CUSTOMER Numeric 6 1 6
2 ITEM Character 12 7 18
3 PRICE Numeric 10 2 19 28
═════
Total 29
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 37
■ DATABASE: PDRIVER.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 NAME Character 30 1 30
2 LINEFEED Character 30 31 60
3 NORMAL Character 50 61 110
4 SMALL Character 50 111 160
5 BOLDON Character 50 161 210
6 BOLDOFF Character 50 211 260
7 _6LPI Character 50 261 310
8 _8LPI Character 50 311 360
9 PORTRAIT Character 50 361 410
10 LANDSCAPE Character 50 411 460
11 RESET Character 50 461 510
12 SPEC_STR1 Character 50 511 560
13 SPEC_STR2 Character 50 561 610
14 SPEC_STR3 Character 50 611 660
15 SPEC_STR4 Character 50 661 710
16 SPEC_STR5 Character 50 711 760
17 RUN_CMD Character 50 761 810
═════
Total 811
■ DATABASE: PHYINV.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CONTROLNO Numeric 8 1 8
2 ITEM Character 12 9 20
3 DESC Character 30 21 50
4 QTY Numeric 7 51 57
5 VENDITEM Character 12 58 69
6 VENDOR Character 10 70 79
7 DATE Date 8 80 87
8 TIME Character 8 88 95
9 COST Numeric 10 2 96 105
10 WAREHOUSE Character 10 106 115
11 LOCATION Character 3 116 118
12 POSTED Logical 1 119 119
13 POSTDATE Date 8 120 127
14 POSTTIME Character 8 128 135
═════
Total 136
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 38
■ DATABASE: POD.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 PO Numeric 6 1 6
2 VENDOR Character 10 7 16
3 ITEM Character 12 17 28
4 DESC Character 30 29 58
5 VENDITEM Character 12 59 70
6 ORDERED Numeric 7 71 77
7 RECEIVED Numeric 7 78 84
8 COST Numeric 10 2 85 94
9 DATE Date 8 95 102
10 ETA Date 8 103 110
11 LASTRECV Date 8 111 118
12 TYPE Character 3 119 121
13 CLASS Character 3 122 124
14 OPEN Logical 1 125 125
15 TAXABLE Logical 1 126 126
═════
Total 127
■ DATABASE: POH.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 PO Numeric 6 1 6
2 VENDOR Character 10 7 16
3 NAME Character 30 17 46
4 ATTN Character 30 47 76
5 ADDR1 Character 30 77 106
6 ADDR2 Character 30 107 136
7 CITY Character 22 137 158
8 STATE Character 2 159 160
9 ZIP Character 10 161 170
10 PHONE Character 14 171 184
11 DATE Date 8 185 192
12 SHIPNAME Character 30 193 222
13 SHIPADDR1 Character 30 223 252
14 SHIPADDR2 Character 30 253 282
15 SHIPCITY Character 22 283 304
16 SHIPSTATE Character 2 305 306
17 SHIPZIP Character 10 307 316
18 SHIPPHONE Character 14 317 330
19 ETA Date 8 331 338
20 SUBTOTAL Numeric 10 2 339 348
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 39
DATABASE: POH.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
21 TAXES Numeric 10 2 349 358
22 ADJUST Numeric 10 2 359 368
23 FREIGHT Numeric 10 2 369 378
24 PAID Numeric 10 2 379 388
25 TERMS Character 20 389 408
26 SHIPPER Character 20 409 428
27 BY Character 30 429 458
28 OPEN Logical 1 459 459
29 PRINTED Logical 1 460 460
30 CLASS Character 3 461 463
31 COMMENT Character 50 464 513
═════
Total 514
■ DATABASE: PROJECTS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 PROJECT Numeric 6 1 6
2 CUSTOMER Numeric 6 7 12
3 DESC Character 30 13 42
4 NOTES Memo 10 43 52
5 RATE Numeric 10 3 53 62
6 AMOUNT Numeric 10 2 63 72
7 DATE Date 8 73 80
8 LASTDATE Date 8 81 88
═════
Total 89
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 40
■ DATABASE: QTR_SUM.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 QUARTER Numeric 1 1 1
2 RHOUR Numeric 7 3 2 8
3 OHOUR Numeric 7 3 9 15
4 PHOUR Numeric 7 3 16 22
5 RPAY Numeric 10 2 23 32
6 OPAY Numeric 10 2 33 42
7 PPAY Numeric 10 2 43 52
8 OTHER Numeric 10 2 53 62
9 SICK_PAY Numeric 10 2 63 72
10 VAC_PAY Numeric 10 2 73 82
11 GROSS Numeric 10 2 83 92
12 FED Numeric 10 2 93 102
13 STATE Numeric 10 2 103 112
14 FICA Numeric 10 2 113 122
15 SDI Numeric 10 2 123 132
16 NET Numeric 10 2 133 142
17 DEDX Numeric 10 2 143 152
18 DEDN Numeric 10 2 153 162
19 LAST_CHECK Character 10 163 172
20 LAST_DATE Date 8 173 180
21 LAST_TIME Character 8 181 188
═════
Total 189
■ DATABASE: QUONOTES.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 QUOTE Numeric 6 1 6
2 NOTES Memo 10 7 16
═════
Total 17
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 41
■ DATABASE: QUOTES.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 QUOTE Numeric 6 1 6
2 CUSTOMER Numeric 6 7 12
3 SHIPNAME Character 30 13 42
4 SHIPADDR1 Character 30 43 72
5 SHIPADDR2 Character 30 73 102
6 SHIPCITY Character 17 103 119
7 SHIPSTATE Character 2 120 121
8 SHIPZIP Character 10 122 131
9 PHONE Character 14 132 145
10 TYPE Character 3 146 148
11 TERMS Character 20 149 168
12 TERMS2 Character 20 169 188
13 AMOUNT2 Numeric 10 2 189 198
14 SHIPPER Character 20 199 218
15 DATE Date 8 219 226
16 TIME Character 8 227 234
17 REG Character 3 235 237
18 BY Character 30 238 267
19 SALESPER Character 3 268 270
20 CUST_PO Character 15 271 285
21 SC Logical 1 286 286
22 BO Numeric 6 287 292
23 TAXRATE Numeric 6 4 293 298
24 TAXES Numeric 10 2 299 308
25 ADJUST Numeric 10 2 309 318
26 FREIGHT Numeric 10 2 319 328
27 SUBTOTAL Numeric 10 2 329 338
28 OPEN Logical 1 339 339
29 PRINTED Logical 1 340 340
30 PAID Numeric 10 2 341 350
31 CLASS Character 3 351 353
32 COMMENT Character 50 354 403
═════
Total 404
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 42
■ DATABASE: QUOTESD.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 QUOTE Numeric 6 1 6
2 ITEM Character 12 7 18
3 DESC Character 30 19 48
4 QTY Numeric 7 49 55
5 PRICE Numeric 10 2 56 65
6 COST Numeric 10 2 66 75
7 TAXABLE Logical 1 76 76
8 DATE Date 8 77 84
9 CUSTOMER Numeric 6 85 90
10 CLASS Character 3 91 93
═════
Total 94
■ DATABASE: REC.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 KEY Numeric 6 1 6
2 PO Numeric 6 7 12
3 VENDOR Character 10 13 22
4 ITEM Character 12 23 34
5 DESC Character 30 35 64
6 VENDITEM Character 12 65 76
7 RECEIVED Numeric 7 77 83
8 COST Numeric 10 2 84 93
9 DATE Date 8 94 101
10 BY Character 30 102 131
11 PC Logical 1 132 132
12 COSTADJ Numeric 10 2 133 142
═════
Total 143
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 43
■ DATABASE: RECEIPTS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 JOURNAL Numeric 6 1 6
2 INVOICE Numeric 6 7 12
3 PROJECT Numeric 6 13 18
4 CUSTOMER Numeric 6 19 24
5 AMOUNT Numeric 10 2 25 34
6 CHECKNO Character 12 35 46
7 TYPE Character 3 47 49
8 DATE Date 8 50 57
9 BY Character 5 58 62
10 APPLIED Numeric 10 2 63 72
11 CLASS Character 3 73 75
═════
Total 76
■ DATABASE: RECHECK.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 RECURRING Numeric 6 1 6
2 NAME Character 30 7 36
3 VE Logical 1 37 37
4 LASTDATE Date 8 38 45
5 SCHEDULE Character 10 46 55
6 PRINT Logical 1 56 56
7 ACCOUNT Character 10 57 66
8 WHATFOR Character 40 67 106
9 CLASS Character 3 107 109
10 TYPE Character 3 110 112
11 AMOUNT Numeric 10 2 113 122
12 SUBTOTAL Numeric 10 2 123 132
13 TAXES Numeric 10 2 133 142
14 FREIGHT Numeric 10 2 143 152
15 ADJUST Numeric 10 2 153 162
16 TOTALPAID Numeric 10 2 163 172
17 ACCTNUM Character 20 173 192
18 NUMBER Character 2 193 194
19 CFORMAT Character 2 195 196
20 ADDR1 Character 30 197 226
21 ADDR2 Character 30 227 256
22 CITY Character 22 257 278
23 STATE Character 2 279 280
24 ZIP Character 10 281 290
25 PHONE Character 14 291 304
26 DATE Date 8 305 312
27 COMMENT Character 50 313 362
═════
Total 363
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 44
■ DATABASE: REGISTER.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 OPEN Logical 1 1 1
2 OPENDATE Date 8 2 9
3 OPENTIME Character 8 10 17
4 CLOSEDATE Date 8 18 25
5 CLOSETIME Character 8 26 33
6 STARTSUM Numeric 10 2 34 43
7 ENDSUM Numeric 10 2 44 53
8 BY Character 30 54 83
═════
Total 84
■ DATABASE: ROLL90.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 GL_ENTRY Character 12 1 12
2 NAME Character 30 13 42
3 PERIOD1 Numeric 10 2 43 52
4 PERIOD2 Numeric 10 2 53 62
5 PERIOD3 Numeric 10 2 63 72
6 PERIOD4 Numeric 10 2 73 82
7 PERIOD5 Numeric 10 2 83 92
8 PERIOD6 Numeric 10 2 93 102
9 PERIOD7 Numeric 10 2 103 112
10 PERIOD8 Numeric 10 2 113 122
11 PERIOD9 Numeric 10 2 123 132
12 PERIOD10 Numeric 10 2 133 142
13 PERIOD11 Numeric 10 2 143 152
14 PERIOD12 Numeric 10 2 153 162
15 PERIOD13 Numeric 10 2 163 172
16 RETAIN Logical 1 173 173
17 RETAINED Numeric 10 2 174 183
18 LAST_BAL Numeric 10 2 184 193
19 BUDGET1 Numeric 10 2 194 203
20 BUDGET2 Numeric 10 2 204 213
21 BUDGET3 Numeric 10 2 214 223
22 BUDGET4 Numeric 10 2 224 233
23 BUDGET5 Numeric 10 2 234 243
24 BUDGET6 Numeric 10 2 244 253
25 BUDGET7 Numeric 10 2 254 263
26 BUDGET8 Numeric 10 2 264 273
27 BUDGET9 Numeric 10 2 274 283
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 45
DATABASE: ROLL90.DBF Continued...
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
28 BUDGET10 Numeric 10 2 284 293
29 BUDGET11 Numeric 10 2 294 303
30 BUDGET12 Numeric 10 2 304 313
31 BUDGET13 Numeric 10 2 314 323
32 DR Character 1 324 324
33 CR Character 1 325 325
34 DATE Date 8 326 333
35 LASTDATE Date 8 334 341
36 ROLL Logical 1 342 342
37 ACCOUNT Character 12 343 354
═════
Total 355
■ DATABASE: SALES.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 DEPARTMENT Character 20 1 20
2 NAME Character 20 21 40
3 CLASS Character 3 41 43
4 SALES Numeric 10 2 44 53
5 COST Numeric 10 2 54 63
6 SALES_YTD Numeric 10 2 64 73
7 COST_YTD Numeric 10 2 74 83
8 ASALES_YTD Numeric 10 2 84 93
9 ACOST_YTD Numeric 10 2 94 103
10 LAST_SYTD Numeric 10 2 104 113
11 GOAL Numeric 10 2 114 123
12 DATE Date 8 124 131
13 LASTDATE Date 8 132 139
═════
Total 140
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 46
■ DATABASE: SALESPER.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 SALESPER Character 3 1 3
2 NAME Character 30 4 33
3 ADDR1 Character 30 34 63
4 ADDR2 Character 30 64 93
5 CITY Character 22 94 115
6 STATE Character 2 116 117
7 ZIP Character 10 118 127
8 PHONE Character 14 128 141
9 DATE Date 8 142 149
10 LASTDATE Date 8 150 157
11 RATE Numeric 10 3 158 167
12 TYPE Character 3 168 170
13 SALESPTD Numeric 10 2 171 180
14 SALESYTD Numeric 10 2 181 190
═════
Total 191
■ DATABASE: SERIALNO.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 ITEM Character 12 1 12
2 INVOICE Numeric 6 13 18
3 SERIALNO Character 30 19 48
4 CUSTOMER Numeric 6 49 54
5 DATE Date 8 55 62
═════
Total 63
■ DATABASE: SHIPPER.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 SHIPPER Character 20 1 20
═════
Total 21
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 47
■ DATABASE: SHIPTOS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CUSTOMER Numeric 6 1 6
2 SHIPNAME Character 30 7 36
3 SHIPADDR1 Character 30 37 66
4 SHIPADDR2 Character 30 67 96
5 SHIPCITY Character 22 97 118
6 SHIPSTATE Character 2 119 120
7 SHIPZIP Character 10 121 130
8 PHONE Character 14 131 144
9 SALESPER Character 3 145 147
10 RATE Numeric 10 3 148 157
11 TAXRATE Numeric 6 4 158 163
12 TERMS Character 20 164 183
13 SHIPPER Character 20 184 203
14 TYPE Character 3 204 206
15 CLASS Character 3 207 209
16 DATE Date 8 210 217
═════
Total 218
■ DATABASE: SO.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 SO Numeric 6 1 6
2 COMMENT Character 30 7 36
3 ENDITEM Character 12 37 48
4 DESC Character 30 49 78
5 QTY Numeric 10 3 79 88
6 COST Numeric 10 3 89 98
7 ASSEMBLED Numeric 10 3 99 108
8 DATE Date 8 109 116
9 DUEDATE Date 8 117 124
10 LASTDATE Date 8 125 132
11 HOURS Numeric 10 3 133 142
12 LABOR Numeric 10 3 143 152
13 LABOR1 Numeric 10 3 153 162
14 LABOR2 Numeric 10 3 163 172
15 PRIORITY Numeric 3 173 175
16 OPEN Logical 1 176 176
17 ALLOCATED Logical 1 177 177
18 PRINTED Logical 1 178 178
19 CUSTOMER Numeric 6 179 184
20 INVOICE Numeric 6 185 190
═════
Total 191
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 47.1
■ DATABASE: TAXCODE.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 TAXCODE Character 1 1 1
2 TAXRATE Numeric 6 4 2 7
═════
Total 8
■ DATABASE: TCHECKS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CHECKNO Character 12 1 12
2 ACCTNUM Character 20 13 32
3 NUMBER Character 2 33 34
4 AMOUNT Numeric 10 2 35 44
5 NAME Character 30 45 74
6 WHATFOR Character 40 75 114
7 DATE Date 8 115 122
8 JOURNAL Numeric 6 123 128
9 ACCOUNT Character 10 129 138
10 CV Logical 1 139 139
11 TYPE Character 3 140 142
12 CFORMAT Character 2 143 144
13 CLASS Character 3 145 147
14 TRANSACT Character 12 148 159
15 BY Character 30 160 189
═════
Total 190
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 48
■ DATABASE: TEMPLATE.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 TEMPLATE Numeric 6 1 6
2 ITEM Character 12 7 18
3 DESC Character 30 19 48
4 QTY Numeric 7 49 55
5 PRICE Numeric 10 2 56 65
6 DATE Date 8 66 73
═════
Total 74
■ DATABASE: TERMS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 TERMS Character 20 1 20
═════
Total 21
■ DATABASE: TOPCUS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 CUSTOMER Numeric 6 1 6
2 NAME Character 30 7 36
3 SALESPER Character 3 37 39
4 REPNAME Character 30 40 69
5 DATE Date 8 70 77
6 SALES Numeric 10 2 78 87
7 COST Numeric 10 2 88 97
8 MARGIN Numeric 7 3 98 104
9 RANKING Numeric 7 105 111
═════
Total 112
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 49
■ DATABASE: TYPE.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 TYPE Character 3 1 3
2 DESC Character 30 4 33
═════
Total 34
■ DATABASE: VENDORS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 VENDOR Character 10 1 10
2 NAME Character 30 11 40
3 ADDR1 Character 30 41 70
4 ADDR2 Character 30 71 100
5 CITY Character 22 101 122
6 STATE Character 2 123 124
7 ZIP Character 10 125 134
8 PHONE Character 14 135 148
9 FAX Character 14 149 162
10 TAXRATE Numeric 6 4 163 168
11 ATTN Character 30 169 198
12 SHIPNAME Character 30 199 228
13 SHIPADDR1 Character 30 229 258
14 SHIPADDR2 Character 30 259 288
15 SHIPCITY Character 22 289 310
16 SHIPSTATE Character 2 311 312
17 SHIPZIP Character 10 313 322
18 SHIPPHONE Character 14 323 336
19 TERMS Character 20 337 356
20 SHIPPER Character 20 357 376
21 DATE Date 8 377 384
22 LASTDATE Date 8 385 392
23 TYPE Character 3 393 395
24 CLASS Character 3 396 398
25 OPEN_PURC Numeric 10 2 399 408
26 RECV_PURC Numeric 10 2 409 418
27 TOT_PURC Numeric 10 2 419 428
28 DUE Numeric 10 2 429 438
29 PAID Numeric 10 2 439 448
30 TOTALPAID Numeric 10 2 449 458
31 FED_ID Character 15 459 473
═════
Total 474
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 50
■ DATABASE: WAREHOUS.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 ITEM Character 12 1 12
2 LOC1 Numeric 7 13 19
3 SLLOC1 Numeric 7 20 26
4 LOC2 Numeric 7 27 33
5 SLLOC2 Numeric 7 34 40
6 LOC3 Numeric 7 41 47
7 SLLOC3 Numeric 7 48 54
8 LOC4 Numeric 7 55 61
9 SLLOC4 Numeric 7 62 68
10 LOC5 Numeric 7 69 75
11 SLLOC5 Numeric 7 76 82
12 LOC6 Numeric 7 83 89
13 SLLOC6 Numeric 7 90 96
14 LOC7 Numeric 7 97 103
15 SLLOC7 Numeric 7 104 110
═════
Total 111
■ DATABASE: WARENAME.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 LOC Character 10 1 10
2 NAME Character 30 11 40
3 COMMENTS Character 40 41 80
═════
Total 81
■ DATABASE: WO_NOTES.DBF
Field Field name Type Width Dec Start End
═════ ══════════ ══════════ ═════ ═════ ═══════ ═══════
1 INVOICE Numeric 6 1 6
2 NOTES Memo 10 7 16
═════
Total 17
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 51
■ DATA DICTIONARY
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
ACCESSES N 8 0 LOOKUP.DBF ║ AMOUNT N 10 2 GLTRANS.DBF
ACCOUNT C 12 0 GL.DBF ║ PROJECTS.DBF
ROLL90.DBF ║ AMOUNT2 N 10 2 ARH.DBF
ACCOUNT C 10 0 CHECKS.DBF ║ INVOICE.DBF
RECHECK.DBF ║ QUOTES.DBF
TCHECKS.DBF ║ AMOUNT_COL N 3 0 CFORMAT.DBF
ACCTNUM C 20 0 TCHECKS.DBF ║ AMOUNT_ROW N 2 0 CFORMAT.DBF
DEPOSITS.DBF ║ APPLIED N 10 2 RECEIPTS.DBF
ACCOUNTS.DBF ║ ASALES_YTD N 10 2 SALES.DBF
EXPENSES.DBF ║ ATTN C 30 0 APH.DBF
CHECKS.DBF ║ POH.DBF
RECHECK.DBF ║ VENDORS.DBF
ACOST_YTD N 10 2 SALES.DBF ║ CUSTOMER.DBF
ACTIVE L 1 0 PAY.DBF ║ AVGCOST N 10 2 INV.DBF
DAYOX.DBF ║ BALANCE N 10 2 ACCOUNTS.DBF
CUSTOMER.DBF ║ BO N 6 0 ARH.DBF
ADDR1 C 30 0 VENDORS.DBF ║ ALLOCATE.DBF
PAY.DBF ║ INVOICE.DBF
SALESPER.DBF ║ QUOTES.DBF
ACCOUNTS.DBF ║ BO N 7 0 INV.DBF
APH.DBF ║ BOLDOFF C 50 0 PDRIVER.DBF
POH.DBF ║ BOLDON C 50 0 PDRIVER.DBF
RECHECK.DBF ║ BOQTY N 7 0 ALLOCATE.DBF
CUSTOMER.DBF ║ BUDGET1 N 12 2 GL.DBF
ADDR2 C 30 0 ACCOUNTS.DBF ║ BUDGET1 N 10 2 ROLL90.DBF
PAY.DBF ║ BUDGET10 N 10 2 ROLL90.DBF
POH.DBF ║ BUDGET10 N 12 2 GL.DBF
VENDORS.DBF ║ BUDGET11 N 12 2 GL.DBF
APH.DBF ║ BUDGET11 N 10 2 ROLL90.DBF
RECHECK.DBF ║ BUDGET12 N 12 2 GL.DBF
SALESPER.DBF ║ BUDGET12 N 10 2 ROLL90.DBF
CUSTOMER.DBF ║ BUDGET13 N 12 2 GL.DBF
ADDR_COL N 2 0 CFORMAT.DBF ║ BUDGET13 N 10 2 ROLL90.DBF
ADDR_ROW N 2 0 CFORMAT.DBF ║ BUDGET2 N 10 2 ROLL90.DBF
ADJUST N 10 2 QUOTES.DBF ║ BUDGET2 N 12 2 GL.DBF
RECHECK.DBF ║ BUDGET3 N 10 2 ROLL90.DBF
EXPENSES.DBF ║ BUDGET3 N 12 2 GL.DBF
APH.DBF ║ BUDGET4 N 12 2 GL.DBF
INVOICE.DBF ║ BUDGET4 N 10 2 ROLL90.DBF
ARH.DBF ║ BUDGET5 N 12 2 GL.DBF
POH.DBF ║ BUDGET5 N 10 2 ROLL90.DBF
ALLOCATED N 7 0 INV.DBF ║ BUDGET6 N 10 2 ROLL90.DBF
AMOUNT N 10 2 APH.DBF ║ BUDGET6 N 12 2 GL.DBF
DEPOSITS.DBF ║ BUDGET7 N 10 2 ROLL90.DBF
RECHECK.DBF ║ BUDGET7 N 12 2 GL.DBF
RECEIPTS.DBF ║ BUDGET8 N 12 2 GL.DBF
TCHECKS.DBF ║ BUDGET8 N 10 2 ROLL90.DBF
EXPENSES.DBF ║ BUDGET9 N 12 2 GL.DBF
CHECKS.DBF ║ BUDGET9 N 10 2 ROLL90.DBF
APPLIED.DBF ║ BUILD_QTY N 7 0 ENDITEMS.DBF
GLHIST.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 52
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
BY C 30 0 QUOTES.DBF ║ CLASS C 3 0 BO.DBF
CHECKS.DBF ║ SHIPTOS.DBF
INVOICE.DBF ║ APH.DBF
TCHECKS.DBF ║ DETAIL.DBF
POH.DBF ║ VENDORS.DBF
ARH.DBF ║ RECEIPTS.DBF
DEPOSITS.DBF ║ TCHECKS.DBF
REGISTER.DBF ║ CUSTOMER.DBF
INVADJ.DBF ║ INVADJ.DBF
REC.DBF ║ DEPOSITS.DBF
BY C 5 0 RECEIPTS.DBF ║ EXPENSES.DBF
APH.DBF ║ ARH.DBF
CALLPRG C 10 0 DAYOHELP.DBF ║ CLOSEDATE D 8 0 REGISTER.DBF
CFORMAT C 2 0 RECHECK.DBF ║ CLOSETIME C 8 0 REGISTER.DBF
CFORMAT.DBF ║ COMMENT C 50 0 ARH.DBF
CHECKS.DBF ║ INVOICE.DBF
TCHECKS.DBF ║ APH.DBF
CHECKNO C 12 0 TCHECKS.DBF ║ RECHECK.DBF
EXPENSES.DBF ║ POH.DBF
CHECKS.DBF ║ COMMENT QUOTES.DBF
APH.DBF ║ COMMENT C 70 0 LOOKUP.DBF
RECEIPTS.DBF ║ COMMENT C 12 0 GLHIST.DBF
CHK_COL N 2 0 CFORMAT.DBF ║ GLTRANS.DBF
CHK_ROW N 2 0 CFORMAT.DBF ║ COMMENTS C 40 0 WARENAME.DBF
CITY C 22 0 POH.DBF ║ CONTROLNO N 8 0 PHYINV.DBF
CUSTOMER.DBF ║ COST N 10 2 INV.DBF
APH.DBF ║ QUOTESD.DBF
ACCOUNTS.DBF ║ SALES.DBF
VENDORS.DBF ║ PHYINV.DBF
SALESPER.DBF ║ ENDITEMS.DBF
RECHECK.DBF ║ POD.DBF
CITY C 20 0 PAY.DBF ║ DETAIL.DBF
CLASS C 3 0 PAY.DBF ║ REC.DBF
QUOTESD.DBF ║ BO.DBF
PAYHIST.DBF ║ INVADJ.DBF
GLCLASS.DBF ║ ALLOCATE.DBF
PAYROLL.DBF ║ ARD.DBF
SALES.DBF ║ TOPCUS.DBF
GLHIST.DBF ║ APD.DBF
INV.DBF ║ COSTADJ N 10 2 REC.DBF
GLTRANS.DBF ║ COST_YTD N 10 2 SALES.DBF
QUOTES.DBF ║ CR C 1 0 ROLL90.DBF
ACCOUNTS.DBF ║ GL.DBF
RECHECK.DBF ║ CREDIT C 12 0 GLHIST.DBF
APD.DBF ║ GLTRANS.DBF
CHECKS.DBF ║ GLCLASS.DBF
ALLOCATE.DBF ║ CSTATE C 2 0 PAYROLL.DBF
POD.DBF ║ PAYHIST.DBF
POH.DBF ║ CURR_DATE D 8 0 PAY.DBF
INVOICE.DBF ║ CURR_DED1 N 10 2 PAY.DBF
ARD.DBF ║ CURR_DED2 N 10 2 PAY.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 53
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
CURR_DED3 N 10 2 PAY.DBF ║ DATE D 8 0 GLHIST.DBF
CURR_DED4 N 10 2 PAY.DBF ║ GLCLASS.DBF
CURR_DED5 N 10 2 PAY.DBF ║ GLTABLED.DBF
CURR_DED6 N 10 2 PAY.DBF ║ GLTABLEH.DBF
CURR_DED7 N 10 2 PAY.DBF ║ GL.DBF
CURR_DED8 N 10 2 PAY.DBF ║ PHYINV.DBF
CURR_DEDN N 10 2 PAY.DBF ║ PROJECTS.DBF
CURR_DEDX N 10 2 PAY.DBF ║ PAYROLL.DBF
CURR_FED N 10 2 PAY.DBF ║ QUOTESD.DBF
CURR_FICA N 10 2 PAY.DBF ║ PAY.DBF
CURR_GROSS N 10 2 PAY.DBF ║ ENDITEMS.DBF
CURR_NET N 10 2 PAY.DBF ║ INV.DBF
CURR_NOTE C 50 0 PAY.DBF ║ SALES.DBF
CURR_OHOUR N 7 3 PAY.DBF ║ LOOKUP.DBF
CURR_OPAY N 10 2 PAY.DBF ║ QUOTES.DBF
CURR_OTHER N 10 2 PAY.DBF ║ GLDEPT.DBF
CURR_PHOUR N 7 3 PAY.DBF ║ ROLL90.DBF
CURR_PPAY N 10 2 PAY.DBF ║ PAYHIST.DBF
CURR_RHOUR N 7 3 PAY.DBF ║ GLTRANS.DBF
CURR_RPAY N 10 2 PAY.DBF ║ INVADJ.DBF
CURR_SDI N 10 2 PAY.DBF ║ ACCOUNTS.DBF
CURR_SICK N 10 2 PAY.DBF ║ DEPOSITS.DBF
CURR_STATE N 10 2 PAY.DBF ║ ARD.DBF
CURR_VAC N 10 2 PAY.DBF ║ POH.DBF
CUSTOMER N 6 0 CUSTMEMO.DBF ║ CHECKS.DBF
PROJECTS.DBF ║ INVOICE.DBF
QUOTES.DBF ║ VENDORS.DBF
QUOTESD.DBF ║ APPLIED.DBF
PB.DBF ║ BO.DBF
CUSTMEMO.DBF ║ SALESPER.DBF
SERIALNO.DBF ║ DETAIL.DBF
ARH.DBF ║ ALLOCATE.DBF
DETAIL.DBF ║ APD.DBF
CUSTOMER.DBF ║ SERIALNO.DBF
BO.DBF ║ POD.DBF
TOPCUS.DBF ║ TEMPLATE.DBF
RECEIPTS.DBF ║ REC.DBF
ALLOCATE.DBF ║ TOPCUS.DBF
ARD.DBF ║ RECHECK.DBF
SHIPTOS.DBF ║ ARH.DBF
INVOICE.DBF ║ CUSTOMER.DBF
CUST_PO C 15 0 INVOICE.DBF ║ TCHECKS.DBF
ARH.DBF ║ EXPENSES.DBF
QUOTES.DBF ║ RECEIPTS.DBF
CV L 1 0 CHECKS.DBF ║ APH.DBF
TCHECKS.DBF ║ SHIPTOS.DBF
CV_NUM_COL N 3 0 CFORMAT.DBF ║ DATE_COL N 3 0 CFORMAT.DBF
CV_NUM_ROW N 2 0 CFORMAT.DBF ║ DATE_ROW N 2 0 CFORMAT.DBF
C_LENGTH N 2 0 CFORMAT.DBF ║ DBSIZE N 8 0 DAYOX.DBF
C_WIDTH N 3 0 CFORMAT.DBF ║ DEBIT C 12 0 GLHIST.DBF
DATABASE C 12 0 GLCLASS.DBF GLTRANS.DBF
LOOKUP.DBF GLCLASS.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 54
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
DEDN N 10 2 PAYROLL.DBF ║ DEDUCT8X L 1 0 PAY.DBF
PAY_SUM.DBF ║ DEDX N 10 2 QTR_SUM.DBF
QTR_SUM.DBF ║ PAYHIST.DBF
PAYHIST.DBF ║ PAYROLL.DBF
DEDUCT1 C 20 0 PAY.DBF ║ PAY_SUM.DBF
DEDUCT1AMT N 10 2 PAYHIST.DBF ║ DEPARTMENT C 20 0 SALES.DBF
PAY.DBF ║ DEPARTMENT C 3 0 PAY.DBF
PAYROLL.DBF ║ DEPOSIT N 6 0 DEPOSITS.DBF
DEDUCT1BAL N 10 2 PAY.DBF ║ DESC C 30 0 INV.DBF
DEDUCT1X L 1 0 PAY.DBF ║ PHYINV.DBF
DEDUCT2 C 20 0 PAY.DBF ║ ENDITEMS.DBF
DEDUCT2AMT N 10 2 PAY.DBF ║ PROJECTS.DBF
PAYHIST.DBF ║ QUOTESD.DBF
PAYROLL.DBF ║ BO.DBF
DEDUCT2BAL N 10 2 PAY.DBF ║ ALLOCATE.DBF
DEDUCT2X L 1 0 PAY.DBF ║ TEMPLATE.DBF
DEDUCT3 C 20 0 PAY.DBF ║ APD.DBF
DEDUCT3AMT N 10 2 PAYHIST.DBF ║ POD.DBF
PAYROLL.DBF ║ REC.DBF
PAY.DBF ║ ARD.DBF
DEDUCT3BAL N 10 2 PAY.DBF ║ TYPE.DBF
DEDUCT3X L 1 0 PAY.DBF ║ DETAIL.DBF
DEDUCT4 C 20 0 PAY.DBF ║ DESC C 50 0 DAYOMENU.DBF
DEDUCT4AMT N 10 2 PAY.DBF ║ DISCOUNT N 10 2 ARH.DBF
PAYROLL.DBF ║ INVOICE.DBF
PAYHIST.DBF ║ DOB D 8 0 PAY.DBF
DEDUCT4BAL N 10 2 PAY.DBF ║ DOH D 8 0 PAY.DBF
DEDUCT4X L 1 0 PAY.DBF ║ DOLLARS N 10 2 INVADJ.DBF
DEDUCT5 C 20 0 PAY.DBF ║ DR C 1 0 GL.DBF
DEDUCT5AMT N 10 2 PAY.DBF ║ ROLL90.DBF
PAYROLL.DBF ║ DUE N 10 2 CUSTOMER.DBF
PAYHIST.DBF ║ VENDORS.DBF
DEDUCT5BAL N 10 2 PAY.DBF ║ ENDITEM C 12 0 BOM.DBF
DEDUCT5X L 1 0 PAY.DBF ║ ENDITEMS.DBF
DEDUCT6 C 20 0 PAY.DBF ║ ENDSUM N 10 2 REGISTER.DBF
DEDUCT6AMT N 10 2 PAYROLL.DBF ║ ENDTIME C 8 0 DAYOX.DBF
PAY.DBF ║ ETA D 8 0 POD.DBF
PAYHIST.DBF ║ POH.DBF
DEDUCT6BAL N 10 2 PAY.DBF ║ EXPENSE N 6 0 EXPENSES.DBF
DEDUCT6X L 1 0 PAY.DBF ║ EXEMPTIONS N 2 0 PAY.DBF
DEDUCT7 C 20 0 PAY.DBF ║ FAILURES N 7 0 DAYOX.DBF
DEDUCT7AMT N 10 2 PAYROLL.DBF ║ FAX C 14 0 CUSTOMER.DBF
PAY.DBF ║ VENDORS.DBF
PAYHIST.DBF ║ FED N 10 2 PAY_SUM.DBF
DEDUCT7BAL N 10 2 PAY.DBF ║ PAYHIST.DBF
DEDUCT7X L 1 0 PAY.DBF ║ QTR_SUM.DBF
DEDUCT8 C 20 0 PAY.DBF ║ PAYROLL.DBF
DEDUCT8AMT N 10 2 PAY.DBF ║ FED_FACTOR N 6 4 PAY.DBF
PAYROLL.DBF ║ FED_FIX N 10 2 PAY.DBF
PAYHIST.DBF ║ FED_ID C 15 0 VENDORS.DBF
DEDUCT8BAL N 10 2 PAY.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 55
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
FICA N 10 2 PAY_SUM.DBF ║ ITEM C 12 0 APD.DBF
PAYROLL.DBF ║ WAREHOUS.DBF
PAYHIST.DBF ║ TEMPLATE.DBF
QTR_SUM.DBF ║ BO.DBF
FIELD C 30 0 GLCLASS.DBF ║ POD.DBF
FILLED N 7 0 BO.DBF ║ REC.DBF
FINIS_QTY N 7 0 ENDITEMS.DBF ║ ALLOCATE.DBF
FOR_COL N 2 0 CFORMAT.DBF ║ PB.DBF
FOR_ROW N 2 0 CFORMAT.DBF ║ JOURNAL N 6 0 RECEIPTS.DBF
FREIGHT N 10 2 POH.DBF ║ APPLIED.DBF
RECHECK.DBF ║ CHECKS.DBF
INVOICE.DBF ║ TCHECKS.DBF
EXPENSES.DBF ║ APD.DBF
APH.DBF ║ ARJ.DBF
ARH.DBF ║ APH.DBF
QUOTES.DBF ║ KEY N 6 0 APD.DBF
FROM_DATE D 8 0 GLPERIOD.DBF ║ REC.DBF
GLCODE C 10 0 GLDEPT.DBF ║ APH.DBF
GLTAB N 6 0 GLTABLED.DBF ║ LANDSCAPE C 50 0 PDRIVER.DBF
GLTABLEH.DBF ║ LASTDATE D 8 0 SALESPER.DBF
GL_ENTRY C 12 0 ROLL90.DBF ║ RECHECK.DBF
GL.DBF ║ DAYOHELP.DBF
GLTABLED.DBF ║ DAYOMENU.DBF
GL_FILTER C 40 0 GLCLASS.DBF ║ ACCOUNTS.DBF
GL_LOGICAL C 12 0 GLCLASS.DBF ║ VENDORS.DBF
GOAL N 10 2 SALES.DBF ║ CUSTOMER.DBF
GROSS N 10 2 QTR_SUM.DBF ║ INV.DBF
PAYHIST.DBF ║ GL.DBF
PAY_SUM.DBF ║ ENDITEMS.DBF
PAYROLL.DBF ║ SALES.DBF
HELPVAR C 10 0 DAYOHELP.DBF ║ LOOKUP.DBF
HELP_NOTE M 10 0 DAYOHELP.DBF ║ ROLL90.DBF
INDEXNAME C 12 0 DAYOX.DBF ║ BOM.DBF
INVOICE N 6 0 ARD.DBF ║ DAYOX.DBF
APPLIED.DBF ║ PROJECTS.DBF
RECEIPTS.DBF ║ LASTRECV D 8 0 POD.DBF
WO_NOTES.DBF ║ LASTTIME C 8 0 DAYOMENU.DBF
DETAIL.DBF ║ ENDITEMS.DBF
ARH.DBF ║ LASTUSER C 30 0 DAYOHELP.DBF
SERIALNO.DBF ║ LAST_BAL N 10 2 ROLL90.DBF
ALLOCATE.DBF ║ LAST_BAL N 12 2 GL.DBF
BO.DBF ║ LAST_CHECK C 10 0 PAY.DBF
INVOICE.DBF ║ QTR_SUM.DBF
ITEM C 12 0 INV.DBF ║ PAY_SUM.DBF
QUOTESD.DBF ║ PAYROLL.DBF
PHYINV.DBF ║ PAYHIST.DBF
BOM.DBF ║ LAST_DATE D 8 0 QTR_SUM.DBF
DETAIL.DBF ║ PAY_SUM.DBF
ARD.DBF ║ LAST_SYTD N 10 2 SALES.DBF
SERIALNO.DBF ║ LAST_TIME C 8 0 PAY_SUM.DBF
INVADJ.DBF QTR_SUM.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 56
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
LDEPOSIT N 10 2 ACCOUNTS.DBF ║ NEXT_KIN C 50 0 PAY.DBF
LIMIT N 10 2 CUSTOMER.DBF ║ NORMAL C 50 0 PDRIVER.DBF
LINEFEED C 30 0 PDRIVER.DBF ║ NOTES M 10 0 WO_NOTES.DBF
LOC C 10 0 WARENAME.DBF ║ CUSTMEMO.DBF
INVADJ.DBF ║ QUONOTES.DBF
LOC1 N 7 0 WAREHOUS.DBF ║ CUSTMEMO.DBF
LOC2 N 7 0 WAREHOUS.DBF ║ PAYNOTES.DBF
LOC3 N 7 0 WAREHOUS.DBF ║ PROJECTS.DBF
LOC4 N 7 0 WAREHOUS.DBF ║ NS L 1 0 INV.DBF
LOC5 N 7 0 WAREHOUS.DBF ║ DETAIL.DBF
LOC6 N 7 0 WAREHOUS.DBF ║ NUMBER C 2 0 TCHECKS.DBF
LOC7 N 7 0 WAREHOUS.DBF ║ RECHECK.DBF
LOCATION C 40 0 DAYOMENU.DBF ║ ACCOUNTS.DBF
LOCATION C 3 0 INV.DBF ║ CHECKS.DBF
LOCATION C 30 0 LOOKUP.DBF ║ EXPENSES.DBF
LOCATION C 40 0 DAYOX.DBF ║ DEPOSITS.DBF
LOCATION C 3 0 PHYINV.DBF ║ NUM_RUNS N 10 0 DAYOMENU.DBF
MARGIN N 7 3 TOPCUS.DBF ║ NTXSIZE N 8 0 DAYOX.DBF
MARITAL C 1 0 PAY.DBF ║ NUMBER C 6 0 PAYNOTES.DBF
MESSAGE C 30 0 DAYOX.DBF ║ PAYROLL.DBF
MODULE C 10 0 DAYOHELP.DBF ║ PAYHIST.DBF
MOREDESC C 50 0 ENDITEMS.DBF ║ PAY.DBF
NAME C 12 0 DAYOX.DBF ║ NUMRECORDS N 8 0 LOOKUP.DBF
NAME C 20 0 SALES.DBF ║ NUMRECORDS N 7 0 DAYOX.DBF
NAME C 30 0 GLTABLEH.DBF ║ OHOUR N 7 3 QTR_SUM.DBF
GLDEPT.DBF ║ PAY_SUM.DBF
GLHIST.DBF ║ PAYHIST.DBF
GLCLASS.DBF ║ PAYROLL.DBF
LOOKUP.DBF ║ OKAYS N 7 0 DAYOX.DBF
GLTRANS.DBF ║ ONHAND N 7 0 INV.DBF
ROLL90.DBF ║ ONORDER N 7 0 INV.DBF
PAY.DBF ║ OPAY N 10 2 PAYHIST.DBF
GL.DBF ║ PAY_SUM.DBF
APH.DBF ║ QTR_SUM.DBF
ACCOUNTS.DBF ║ PAYROLL.DBF
CUSTOMER.DBF ║ OPEN L 1 0 QUOTES.DBF
TCHECKS.DBF ║ POH.DBF
CFORMAT.DBF ║ APH.DBF
TOPCUS.DBF ║ APD.DBF
SALESPER.DBF ║ POD.DBF
WARENAME.DBF ║ INVOICE.DBF
CHECKS.DBF ║ REGISTER.DBF
VENDORS.DBF ║ ARH.DBF
RECHECK.DBF ║ OPENDATE D 8 0 REGISTER.DBF
PDRIVER.DBF ║ OPENTIME C 8 0 REGISTER.DBF
POH.DBF ║ OPEN_PURC N 10 2 VENDORS.DBF
NAME_COL N 2 0 CFORMAT.DBF ║ OPEN_QTY N 7 0 ENDITEMS.DBF
NAME_ROW N 2 0 CFORMAT.DBF ║ OPERAND C 40 0 DAYOX.DBF
NET N 10 2 PAYHIST.DBF ║ ORDERED N 7 0 POD.DBF
PAYROLL.DBF
PAY_SUM.DBF
QTR_SUM.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 57
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
OTHER N 10 2 QTR_SUM.DBF ║ PERIOD9 N 10 2 ROLL90.DBF
PAY.DBF ║ PERIOD9 N 12 2 GL.DBF
PAYHIST.DBF ║ PER_QTY N 7 0 BOM.DBF
PAY_SUM.DBF ║ PHONE C 14 0 PAY.DBF
PAYROLL.DBF ║ QUOTES.DBF
OT_HOURS N 7 3 PAY.DBF ║ SHIPTOS.DBF
OVERRIDE L 1 0 ENDITEMS.DBF ║ CUSTOMER.DBF
BOM.DBF ║ POH.DBF
PAID N 10 2 APH.DBF ║ RECHECK.DBF
INVOICE.DBF ║ INVOICE.DBF
VENDORS.DBF ║ ARH.DBF
ARH.DBF ║ APH.DBF
POH.DBF ║ ACCOUNTS.DBF
QUOTES.DBF ║ SALESPER.DBF
PAID_PURC N 10 2 CUSTOMER.DBF ║ VENDORS.DBF
PARTTIME L 1 0 PAY.DBF ║ PHOUR N 7 3 PAY_SUM.DBF
PASSWORD C 7 0 LOOKUP.DBF ║ PAYHIST.DBF
DAYOMENU.DBF ║ QTR_SUM.DBF
PAY L 1 0 ALLOCATE.DBF ║ PAYROLL.DBF
BO.DBF ║ PO N 6 0 POD.DBF
PAYDATE D 8 0 APH.DBF ║ REC.DBF
PAYPERIOD C 1 0 PAY.DBF ║ POH.DBF
PBL N 6 3 CUSTOMER.DBF ║ APD.DBF
PBM N 6 3 CUSTOMER.DBF ║ APH.DBF
PC L 1 0 REC.DBF ║ PODATE D 8 0 APH.DBF
APH.DBF ║ PORTRAIT C 50 0 PDRIVER.DBF
PERIOD C 30 0 GLPERIOD.DBF ║ POSTDATE D 8 0 PHYINV.DBF
PERIOD1 N 10 2 ROLL90.DBF ║ POSTED L 1 0 PHYINV.DBF
PERIOD1 N 12 2 GL.DBF ║ POSTTIME C 8 0 PHYINV.DBF
PERIOD10 N 12 2 GL.DBF ║ ARH.DBF
PERIOD10 N 10 2 ROLL90.DBF ║ ARD.DBF
PERIOD11 N 10 2 ROLL90.DBF ║ PRICE N 10 2 PB.DBF
PERIOD11 N 12 2 GL.DBF ║ DETAIL.DBF
PERIOD12 N 12 2 GL.DBF ║ ARD.DBF
PERIOD12 N 10 2 ROLL90.DBF ║ ALLOCATE.DBF
PERIOD13 N 10 2 ROLL90.DBF ║ TEMPLATE.DBF
PERIOD13 N 12 2 GL.DBF ║ BO.DBF
PERIOD2 N 10 2 ROLL90.DBF ║ INVADJ.DBF
PERIOD2 N 12 2 GL.DBF ║ QUOTESD.DBF
PERIOD3 N 10 2 ROLL90.DBF ║ INV.DBF
PERIOD3 N 12 2 GL.DBF ║ PRINT L 1 0 RECHECK.DBF
PERIOD4 N 10 2 ROLL90.DBF ║ PRINTED L 1 0 INVOICE.DBF
PERIOD4 N 12 2 GL.DBF ║ APH.DBF
PERIOD5 N 10 2 ROLL90.DBF ║ POH.DBF
PERIOD5 N 12 2 GL.DBF ║ ARH.DBF
PERIOD6 N 12 2 GL.DBF ║ PAY.DBF
PERIOD6 N 10 2 ROLL90.DBF ║ QUOTES.DBF
PERIOD7 N 12 2 GL.DBF ║ PROGRAM C 15 0 DAYOMENU.DBF
PERIOD7 N 10 2 ROLL90.DBF ║ PROG_NAME C 12 0 DAYOMENU.DBF
PERIOD8 N 12 2 GL.DBF
PERIOD8 N 10 2 ROLL90.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 58
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
PROJECT N 6 0 APPLIED.DBF ║ QUARTER4 N 10 2 PAY.DBF
DETAIL.DBF ║ QUOTE N 6 0 QUOTESD.DBF
INVOICE.DBF ║ QUONOTES.DBF
RECEIPTS.DBF ║ QUOTES.DBF
PROJECTS.DBF ║ RANKING N 7 0 TOPCUS.DBF
PROMISED D 8 0 INVOICE.DBF ║ RATE N 10 3 PROJECTS.DBF
PPAY N 10 2 PAYHIST.DBF ║ RATE N 10 3 CUSTOMER.DBF
PAY_SUM.DBF ║ SALESPER.DBF
QTR_SUM.DBF ║ SHIPTOS.DBF
PAYROLL.DBF ║ RATE N 10 4 PAY.DBF
PTD_QTY N 7 0 ENDITEMS.DBF ║ REALCOST N 10 2 INV.DBF
BOM.DBF ║ REASON C 30 0 INVADJ.DBF
P_HOURS N 7 3 PAY.DBF ║ RECDATE D 8 0 APD.DBF
QTR_DED1 N 10 2 PAY.DBF ║ APH.DBF
QTR_DED2 N 10 2 PAY.DBF ║ RECEIVED N 7 0 REC.DBF
QTR_DED3 N 10 2 PAY.DBF ║ POD.DBF
QTR_DED4 N 10 2 PAY.DBF ║ RECNO N 7 0 ALLOCATE.DBF
QTR_DED5 N 10 2 PAY.DBF ║ RECURRING N 6 0 RECHECK.DBF
QTR_DED6 N 10 2 PAY.DBF ║ RECV_PURC N 10 2 VENDORS.DBF
QTR_DED7 N 10 2 PAY.DBF ║ REG C 3 0 QUOTES.DBF
QTR_DED8 N 10 2 PAY.DBF ║ REG INVOICE.DBF
QTR_DEDN N 10 2 PAY.DBF ║ REG_HOURS N 7 3 PAY.DBF
QTR_DEDX N 10 2 PAY.DBF ║ REPNAME C 30 0 TOPCUS.DBF
QTR_FED N 10 2 PAY.DBF ║ REQ_QTY N 7 0 BOM.DBF
QTR_FICA N 10 2 PAY.DBF ║ RESET C 50 0 PDRIVER.DBF
QTR_GROSS N 10 2 PAY.DBF ║ RETAIL N 10 2 INV.DBF
QTR_NET N 10 2 PAY.DBF ║ RETAIN L 1 0 GL.DBF
QTR_OHOUR N 10 3 PAY.DBF ║ ROLL90.DBF
QTR_OPAY N 10 2 PAY.DBF ║ RETAINED N 10 2 ROLL90.DBF
QTR_OTHER N 10 2 PAY.DBF ║ RETAINED N 12 2 GL.DBF
QTR_PHOUR N 10 3 PAY.DBF ║ RHOUR N 7 3 PAY_SUM.DBF
QTR_PPAY N 10 2 PAY.DBF ║ PAYHIST.DBF
QTR_RHOUR N 10 3 PAY.DBF ║ QTR_SUM.DBF
QTR_RPAY N 10 2 PAY.DBF ║ PAYROLL.DBF
QTR_SDI N 10 2 PAY.DBF ║ ROLL L 1 0 ROLL90.DBF
QTR_SICK N 10 2 PAY.DBF ║ GL.DBF
QTR_STATE N 10 2 PAY.DBF ║ RPAY N 10 2 PAY_SUM.DBF
QTR_VAC N 10 2 PAY.DBF ║ PAYROLL.DBF
QTY N 7 0 QUOTESD.DBF ║ QTR_SUM.DBF
PHYINV.DBF ║ PAYHIST.DBF
ALLOCATE.DBF ║ RUN_CMD C 50 0 PDRIVER.DBF
TEMPLATE.DBF ║ SALES N 10 2 SALES.DBF
INVADJ.DBF ║ TOPCUS.DBF
ARD.DBF ║ SALESPER C 3 0 CUSTOMER.DBF
BO.DBF ║ ARH.DBF
DETAIL.DBF ║ SALESPER.DBF
QUANTITY N 7 0 APD.DBF ║ TOPCUS.DBF
QUARTER N 1 0 QTR_SUM.DBF ║ SHIPTOS.DBF
QUARTER1 N 10 2 PAY.DBF ║ INVOICE.DBF
QUARTER2 N 10 2 PAY.DBF ║ SALESPER C 3 0 QUOTES.DBF
QUARTER3 N 10 2 PAY.DBF ║ SALESPTD N 10 2 SALESPER.DBF
CUSTOMER.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 59
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
SALESYTD N 10 2 CUSTOMER.DBF ║ SHIPPER C 20 0 QUOTES.DBF
SALESPER.DBF ║ POH.DBF
SALES_YTD N 10 2 SALES.DBF ║ VENDORS.DBF
SC L 1 0 QUOTES.DBF ║ APH.DBF
INVOICE.DBF ║ INVOICE.DBF
ARH.DBF ║ SHIPPER.DBF
SCHEDULE C 10 0 RECHECK.DBF ║ CUSTOMER.DBF
SDI N 10 2 PAYROLL.DBF ║ ARH.DBF
PAY_SUM.DBF ║ SHIPTOS.DBF
PAYHIST.DBF ║ SHIPPHONE C 14 0 VENDORS.DBF
QTR_SUM.DBF ║ POH.DBF
SERIALNO L 1 0 INV.DBF ║ APH.DBF
SERIALNO C 30 0 SERIALNO.DBF ║ SHIPSTATE C 2 0 QUOTES.DBF
SETUP C 50 0 CFORMAT.DBF ║ SHIPTOS.DBF
SEX C 1 0 PAY.DBF ║ INVOICE.DBF
SHIPADDR1 C 30 0 QUOTES.DBF ║ VENDORS.DBF
SHIPTOS.DBF ║ ARH.DBF
ARH.DBF ║ POH.DBF
VENDORS.DBF ║ CUSTOMER.DBF
APH.DBF ║ APH.DBF
CUSTOMER.DBF ║ SHIPZIP C 10 0 POH.DBF
INVOICE.DBF ║ APH.DBF
POH.DBF ║ VENDORS.DBF
SHIPADDR2 C 30 0 SHIPTOS.DBF ║ INVOICE.DBF
APH.DBF ║ ARH.DBF
CUSTOMER.DBF ║ SHIPTOS.DBF
ARH.DBF ║ CUSTOMER.DBF
VENDORS.DBF ║ QUOTES.DBF
POH.DBF ║ SICK_DAYS N 7 3 PAY.DBF
INVOICE.DBF ║ SICK_PAY N 10 2 PAYHIST.DBF
QUOTES.DBF ║ PAY.DBF
SHIPCITY C 17 0 QUOTES.DBF ║ PAY_SUM.DBF
INVOICE.DBF ║ PAYROLL.DBF
ARH.DBF ║ QTR_SUM.DBF
SHIPCITY C 22 0 VENDORS.DBF ║ SICK_PER N 7 3 PAY.DBF
CUSTOMER.DBF ║ SICK_USED N 7 3 PAY.DBF
APH.DBF ║ SIGN C 1 0 GLTABLED.DBF
SHIPTOS.DBF ║ SIZE N 10 0 LOOKUP.DBF
POH.DBF ║ SLLOC1 N 7 0 WAREHOUS.DBF
SHIPNAME C 30 0 CUSTOMER.DBF ║ SLLOC2 N 7 0 WAREHOUS.DBF
POH.DBF ║ SLLOC3 N 7 0 WAREHOUS.DBF
APH.DBF ║ SLLOC4 N 7 0 WAREHOUS.DBF
ARH.DBF ║ SLLOC5 N 7 0 WAREHOUS.DBF
VENDORS.DBF ║ SLLOC6 N 7 0 WAREHOUS.DBF
INVOICE.DBF ║ SLLOC7 N 7 0 WAREHOUS.DBF
SHIPTOS.DBF ║ SMALL C 50 0 PDRIVER.DBF
QUOTES.DBF ║ SOLDPTD N 7 0 INV.DBF
║ SOLDYTD N 7 0 INV.DBF
║ SPEC_STR1 C 50 0 PDRIVER.DBF
║ SPEC_STR2 C 50 0 PDRIVER.DBF
║ SPEC_STR3 C 50 0 PDRIVER.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 60
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
SPEC_STR4 C 50 0 PDRIVER.DBF ║ TAXRATE N 6 4 INVOICE.DBF
SPEC_STR5 C 50 0 PDRIVER.DBF ║ CUSTOMER.DBF
SSN C 11 0 PAY.DBF ║ TAXCODE.DBF
STARTSUM N 10 2 REGISTER.DBF ║ VENDORS.DBF
STARTTIME C 8 0 DAYOX.DBF ║ SHIPTOS.DBF
STATE C 2 0 CUSTOMER.DBF ║ ARH.DBF
RECHECK.DBF ║ QUOTES.DBF
ACCOUNTS.DBF ║ TAX_STATE C 2 0 PAY.DBF
POH.DBF ║ TEMPLATE N 6 0 TEMPLATE.DBF
APH.DBF ║ TERMS C 20 0 TERMS.DBF
VENDORS.DBF ║ POH.DBF
SALESPER.DBF ║ ARH.DBF
PAY.DBF ║ APH.DBF
STATE N 10 2 PAY_SUM.DBF ║ SHIPTOS.DBF
PAYHIST.DBF ║ INVOICE.DBF
QTR_SUM.DBF ║ CUSTOMER.DBF
PAYROLL.DBF ║ VENDORS.DBF
STATE_FIX N 10 2 PAY.DBF ║ QUOTES.DBF
STATE_RATE N 10 4 PAY.DBF ║ TERMS2 C 20 0 ARH.DBF
STATUS C 3 0 PAY.DBF ║ INVOICE.DBF
STOCKLEVEL N 7 0 INV.DBF ║ QUOTES.DBF
SUBAMOUNT N 10 2 CHECKS.DBF ║ THE_GROSS N 10 2 PAY.DBF
SUBTOTAL N 10 2 ARH.DBF ║ TI L 1 0 INV.DBF
APH.DBF ║ DETAIL.DBF
EXPENSES.DBF ║ TIME C 8 0 ALLOCATE.DBF
RECHECK.DBF ║ BO.DBF
POH.DBF ║ ARH.DBF
INVOICE.DBF ║ INVOICE.DBF
QUOTES.DBF ║ PAYROLL.DBF
TAXABLE L 1 0 INV.DBF ║ QUOTES.DBF
QUOTESD.DBF ║ PAYHIST.DBF
ARD.DBF ║ PHYINV.DBF
BO.DBF ║ TITLE L 1 0 GL.DBF
APD.DBF ║ TOTALPAID N 10 2 RECHECK.DBF
ALLOCATE.DBF ║ VENDORS.DBF
APD.DBF ║ TOT_PURC N 10 2 VENDORS.DBF
DETAIL.DBF ║ TO_DATE D 8 0 GLPERIOD.DBF
POD.DBF ║ TRANSACT C 12 0 GLHIST.DBF
TAXCODE C 1 0 TAXCODE.DBF ║ PAYROLL.DBF
TAXCODE C 3 0 CUSTOMER.DBF ║ GLTRANS.DBF
ARH.DBF ║ PAYHIST.DBF
TAXES N 10 2 QUOTES.DBF ║ APH.DBF
POH.DBF ║ EXPENSES.DBF
ARH.DBF ║ TCHECKS.DBF
INVOICE.DBF ║ DEPOSITS.DBF
EXPENSES.DBF ║ ARD.DBF
APH.DBF ║ ARH.DBF
RECHECK.DBF ║ ACCOUNTS.DBF
║ APD.DBF
║ CHECKS.DBF
║ INVADJ.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 61
Field Name Type Len Dec Database Field Name Type Len Dec Database
────────── ──── ─── ─── ──────────── ────────── ──── ─── ─── ────────────
TYPE C 3 0 RECHECK.DBF ║ WAREHOUSE C 10 0 PHYINV.DBF
CHECKS.DBF ║ WEIGHT N 8 2 INV.DBF
SHIPTOS.DBF ║ WHATFOR C 40 0 RECHECK.DBF
INVOICE.DBF ║ CHECKS.DBF
TCHECKS.DBF ║ TCHECKS.DBF
ACCOUNTS.DBF ║ DEPOSITS.DBF
VENDORS.DBF ║ EXPENSES.DBF
EXPENSES.DBF ║ WIP_QTY N 7 0 BOM.DBF
SALESPER.DBF ║ WITHHOLD L 1 0 PAY.DBF
APD.DBF ║ WORD_COL N 2 0 CFORMAT.DBF
POD.DBF ║ WORD_ROW N 2 0 CFORMAT.DBF
APH.DBF ║ YTD_DED1 N 10 2 PAY.DBF
TYPE.DBF ║ YTD_DED2 N 10 2 PAY.DBF
ARH.DBF ║ YTD_DED3 N 10 2 PAY.DBF
CUSTOMER.DBF ║ YTD_DED4 N 10 2 PAY.DBF
DEPOSITS.DBF ║ YTD_DED5 N 10 2 PAY.DBF
RECEIPTS.DBF ║ YTD_DED6 N 10 2 PAY.DBF
INV.DBF ║ YTD_DED7 N 10 2 PAY.DBF
QUOTES.DBF ║ YTD_DED8 N 10 2 PAY.DBF
PAY.DBF ║ YTD_DEDN N 10 2 PAY.DBF
PAYROLL.DBF ║ YTD_DEDX N 10 2 PAY.DBF
PAYHIST.DBF ║ YTD_FED N 10 2 PAY.DBF
UNIT C 3 0 INV.DBF ║ YTD_FICA N 10 2 PAY.DBF
USE_SDI L 1 0 PAY.DBF ║ YTD_GROSS N 10 2 PAY.DBF
VAC_DAYS N 7 3 PAY.DBF ║ YTD_NET N 10 2 PAY.DBF
VAC_PAY N 10 2 PAY_SUM.DBF ║ YTD_OHOUR N 10 3 PAY.DBF
PAYROLL.DBF ║ YTD_OPAY N 10 2 PAY.DBF
PAYHIST.DBF ║ YTD_OTHER N 10 2 PAY.DBF
PAY.DBF ║ YTD_PHOUR N 10 3 PAY.DBF
QTR_SUM.DBF ║ YTD_PPAY N 10 2 PAY.DBF
VAC_PER N 7 3 PAY.DBF ║ YTD_QTY N 7 0 BOM.DBF
VAC_USED N 7 3 PAY.DBF ║ ENDITEMS.DBF
VE L 1 0 RECHECK.DBF ║ YTD_RHOUR N 10 3 PAY.DBF
VENDITEM C 12 0 POD.DBF ║ YTD_RPAY N 10 2 PAY.DBF
REC.DBF ║ YTD_SDI N 10 2 PAY.DBF
INVADJ.DBF ║ YTD_SICK N 10 2 PAY.DBF
APD.DBF ║ YTD_STATE N 10 2 PAY.DBF
INV.DBF ║ YTD_VAC N 10 2 PAY.DBF
PHYINV.DBF ║ ZIP C 10 0 PAY.DBF
VENDOR C 10 0 INV.DBF ║ SALESPER.DBF
PHYINV.DBF ║ APH.DBF
APD.DBF ║ VENDORS.DBF
POD.DBF ║ POH.DBF
REC.DBF ║ ACCOUNTS.DBF
POH.DBF ║ RECHECK.DBF
APH.DBF ║ CUSTOMER.DBF
VENDORS.DBF ║ _6LPI C 50 0 PDRIVER.DBF
V_1ST_LINE N 2 0 CFORMAT.DBF ║ _8LPI C 50 0 PDRIVER.DBF
V_END_LINE N 2 0 CFORMAT.DBF
V_LCOLUMN N 2 0 CFORMAT.DBF
V_RCOLUMN N 3 0 CFORMAT.DBF
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 62
■ QUIRKS
On occasion (maybe an under statement), index files will get corrupted,
especially on networks. To 'fix' a corrupted index requires that everyone
'get out of' the affected DAYO databases, and then perform a reindex
(actually a recreation of the indexes). The reindex is accomplished by
running the an individual module with the parameter of INDEX, ie:
C:\>DAYOINV INDEX
Or by using the DAYO Index module (DAYOX.EXE).
If you are on a multiuser network, you must 'flag' (change file
attributes) of all files to make them sharable, readable and writable. Note
that the command/program 'flag' may be called by a different name on your
network.
ie [ for Novell (tm) ]:
E:\>FLAG *.NTX SRW
Or just to be safe, go ahead and flag all files in the directory:
E:\>FLAG *.* SRW
Indexes are recreated once every day. This is automatically performed by
the first user to run a DAYO module. This process will take more time as your
files get larger. This process should take place daily, but you can run it at
night with a batch file that waits until after midnight (ie: DAYO Clock), or
a with most scheduling programs. All other users and computers must be out of
the databases, or the procedure will not occur properly. Remember to 'flag'
the files sharable, readable and writable.
Backups of your data and configuration files should take place daily! You
have no doubt heard many scare stories. They are all true! The key files that
need to be backed up all have the extension of '.DBF', and '.CFG'. The files
with with the extension of '.DBF' are the databases, and the files with the
extension of '.CFG' contain configuration data/information (as set/seen in
the Configuration Menus on each module).
If you are on a network, the use of dBase III+ with DAYO databases
increases the chances of 'bad bytes' (bad records) placed in the databases.
Records appended past this 'bad byte' may not be accessible. If you think
you have a bad record, use the BAD RECORD routine/report to verify and fix
it.
If you must use dBase with DAYO Price Book, be sure to SET EXCLUSIVE OFF
before you open ANY databases. This will allow the opened databases to be
shared, and more importantly, prevent a user (or all users!) from 'crashing'!
DAYO BUSINESS APPLICATIONS, Copyright (c) 1989-91, TJS LAB Page: 63
If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then
do not use it...
The FILES statement in the CONFIG.SYS file must be set to at least 65,
ie: FILES=65. Edit your CONFIG.SYS file and insure the changes, or run the
DAYO MENU program which automatically checks this each time it is run.
■ 'CREDITS'
Clipper, a trademark of Nantucket Corporation
dBASE III/III+/IV, a trademark of Ashton-Tate, Inc.
Hewlett Packard LaserJet, a trademark of Hewlett Packard Company
IBM PC-DOS/PC/XT/AT/PS2, a trademark of International Business Machines
Corporation
Novell, Novell Inc.
FUNCKy, dLESKO Associates.
■ SUGGESTIONS
DAYO grows based on requests and suggestions from you, the user. If you
experience a problem with DAYO, or would like to see a change, addition or
'fix', then please drop us a note with your ideas. If TJS LAB deems your
suggestion a good one (applicable to other users), we may create it. Note,
we can not guarantee if or when a suggestion will be acted on; however, we
do make 'paid' modifications at the rate of $35.00/hr. If we do act on your
idea, we will send you a copy of the 'finished product' free...
Send Suggestions to: TJS LAB
PO Box 585366
Orlando, Florida 32858-5366
Or call us with those HOT ideas at: (407) 291-3960